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 |
ORA-32008: error while processing parameter update at instance string
SQL*Loader-00947: subpartition load requested and string has enabled triggers or constraints
ORA-29336: Internal error [string] [string] from DBMS_PLUGTS
RMAN-06554: WARNING: file string is in backup mode
ORA-07599: spwat: $SCHDWK failure
ORA-16227: DDL skipped due to missing object
ORA-16121: applying transaction with commit SCN string
ORA-31406: change source string is referenced by a change set
ORA-25175: no PRIMARY KEY constraint found
ORA-14166: missing INTO keyword
QSM-02102: mv FROM list references an object in the SYS schema
ORA-24155: rule string.string not in rule set string.string