Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01743: only pure functions can be indexed
- 1 Answers
- 6585 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-31019: Recursive deletion snapshot too old for string/string
ORA-24802: user defined lob read callback error
RMAN-06022: invalid level specified for image copy: number
ORA-28174: Kerberos ticket not provided by proxy
ORA-31520: CDC subscription string already subscribes to publication ID string
PLS-00231: function 'string' may not be used in SQL
PLS-00315: Implementation restriction: unsupported table index type
RMAN-06137: must have recovery catalog for REPORT SCHEMA AT TIME
ORA-07621: smscre: illegal redo block size
ORA-12155: TNS:received bad datatype in NSWMARKER packet
RMAN-12009: command aborted because some backup pieces could not be located
PLS-00509: Implementation Restriction : Pass a returned record to a temporary identifier before selecting a field
Oracle Errors 
