ORA-01743: only pure functions can be indexed



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

Post New Answer

More Oracle Errors Interview Questions

QSM-02010: join predicate with operator other than equals (=)

1 Answers  


NNL-00274: server not started, errors follow

1 Answers  


PLS-00235: the external type is not appropriate for the parameter

1 Answers  


ORA-32104: cannot retrieve OCI error message

1 Answers  


ORA-00101: invalid specification for system parameter DISPATCHERS

1 Answers  






NZE-28753: failure to terminate use of data source

1 Answers  


ORA-31692: The following SQL statement failed trying to insert a row into the Master table: string

1 Answers  


ORA-23292: The constraint does not exist

1 Answers  


LFI-00135: Unable to remove temporary file.

1 Answers  


NNL-00557: Causes the controller to sleep for N seconds

1 Answers  


ORA-27199: skgfpst: sbtpcstatus returned error

1 Answers  


RMAN-06706: could not close file: "string" (reason=string)

1 Answers  


Categories