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 |
PLS-00306: wrong number or types of arguments in call to 'string'
QSM-02055: mv references a packed object table or view
LSX-00173: ~S of ~S type is not a valid restriction of ~S of ~S type
ORA-19592: wrong string conversation type
ORA-32700: error occurred in DIAG Group Service
ORA-28113: policy predicate has error
O2I-00112: Unable to write to the HFILE file
LPX-00257: invalid children specification in element declaration
ORA-09966: scumnt: translation error while expanding ?/dbs/lk
ORA-14059: partition "string": INITRANS value must be less than MAXTRANS value
ORA-24163: dblink is not supported in rules engine DDLs
ORA-38488: attribute set already assigned to the column storing expressions