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

PLS-00306: wrong number or types of arguments in call to 'string'

1 Answers  


QSM-02055: mv references a packed object table or view

1 Answers  


LSX-00173: ~S of ~S type is not a valid restriction of ~S of ~S type

1 Answers  


ORA-19592: wrong string conversation type

1 Answers  


ORA-32700: error occurred in DIAG Group Service

1 Answers  






ORA-28113: policy predicate has error

1 Answers  


O2I-00112: Unable to write to the HFILE file

1 Answers  


LPX-00257: invalid children specification in element declaration

1 Answers  


ORA-09966: scumnt: translation error while expanding ?/dbs/lk

1 Answers  


ORA-14059: partition "string": INITRANS value must be less than MAXTRANS value

1 Answers  


ORA-24163: dblink is not supported in rules engine DDLs

1 Answers  


ORA-38488: attribute set already assigned to the column storing expressions

1 Answers  


Categories