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

ORA-32010: cannot find entry to delete in SPFILE

1 Answers  


ORA-01425: escape character must be character string of length 1

1 Answers  


NNC-00407: alias loop in name request

1 Answers  


ORA-31513: unsupported column type specified in change table

1 Answers  


ORA-30515: suspend triggers cannot have BEFORE type

1 Answers  






PCC-00093: Invalid or obsolete option, ignored

1 Answers  


RMAN-06113: changed archive log available

1 Answers  


NNO-00617: enabling AUTHORITY-REQUIRED on system queries

1 Answers  


LPX-00602: Invalid child element '~1S' of element '~2S'.

1 Answers  


IMP-00027: failed to rollback partial import of previous table

1 Answers  


RMAN-20009: database incarnation already registered

1 Answers  


PCC-01011: USAGE IS BINARY clause must be terminated by "." on same line

1 Answers  


Categories