Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01743: only pure functions can be indexed
- 1 Answers
- 6543 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The indexed function uses SYSDATE or the user
environment.
Action: PL/SQL functions must be pure (RNDS, RNPS, WNDS,
WNPS). SQL expressions must not use SYSDATE, USER,
USERENV(), or anything else dependent on the session state.
NLS-dependent functions are OK.
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 0 No |
SQL*Loader-00473: nesting of collections is not allowed.
ORA-02773: Invalid maximum client wait time
EXP-00059: error converting an object type's identifier to characters
ORA-31449: invalid value for change_set_name
TNS-00134: Missing COMMUNITY component in addresses for the Navigator in TNSNAV.ORA
ORA-13517: Baseline (id = string) does not exist
ORA-07501: scgtoa: $deq unexpected return
ORA-02783: Both post and wait functions were not specified
TNS-12670: Incorrect role password
DRG-11846: Response Is Stale
ORA-19815: WARNING: string of string bytes is string used, and has string remaining bytes available.
ORA-02779: Stat failed on core dump directory
Oracle Errors 
