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 |
QSM-02010: join predicate with operator other than equals (=)
NNL-00274: server not started, errors follow
PLS-00235: the external type is not appropriate for the parameter
ORA-32104: cannot retrieve OCI error message
ORA-00101: invalid specification for system parameter DISPATCHERS
NZE-28753: failure to terminate use of data source
ORA-31692: The following SQL statement failed trying to insert a row into the Master table: string
ORA-23292: The constraint does not exist
LFI-00135: Unable to remove temporary file.
NNL-00557: Causes the controller to sleep for N seconds
ORA-27199: skgfpst: sbtpcstatus returned error
RMAN-06706: could not close file: "string" (reason=string)