ORA-01743: only pure functions can be indexed
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 |
ORA-32010: cannot find entry to delete in SPFILE
ORA-01425: escape character must be character string of length 1
NNC-00407: alias loop in name request
ORA-31513: unsupported column type specified in change table
ORA-30515: suspend triggers cannot have BEFORE type
PCC-00093: Invalid or obsolete option, ignored
RMAN-06113: changed archive log available
NNO-00617: enabling AUTHORITY-REQUIRED on system queries
LPX-00602: Invalid child element '~1S' of element '~2S'.
IMP-00027: failed to rollback partial import of previous table
RMAN-20009: database incarnation already registered
PCC-01011: USAGE IS BINARY clause must be terminated by "." on same line