Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01743: only pure functions can be indexed
- 1 Answers
- 6629 Views
- I also Faced
- E-Mail Answers
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-07452: specified resource manager plan does not exist in the data dictionary
ORA-12442: policy column "string" already used by an existing policy
PLS-00358: column 'string' exists in more than one table; use qualifier
ORA-39054: missing or invalid definition of the SQL output file.
ORA-14320: DEFAULT cannot be specified for ADD/DROP VALUES or SPLIT
ORA-31674: worker process interrupt for unhandled exception in master process
SQL-02144: Invalid ANSI dynamic usage
RMAN-06060: WARNING: skipping datafile compromises tablespace string recoverability
ORA-13498: %s
SQL*Loader-00953: Error shipping read buffer across 2-task
NNO-00051: domain count number exceeds maximum of number, first number will be loaded
ORA-01858: a non-numeric character was found where a numeric was expected
Oracle Errors 
