Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01743: only pure functions can be indexed
- 1 Answers
- 6739 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-02028: fetching an exact number of rows is not supported by the server
ORA-38478: creation of system trigger EXPFIL_DROPOBJ_MAINT failed
ORA-01693: max # extents (string) reached in lob segment string.string
ORA-16524: unsupported operation
TNS-04063: Remote administration disabled in the Oracle Connection Manager instance.
ORA-06616: LU6.2 Driver: Attach to LU failed
ORA-26083: unsupported direct path stream version string
NNO-00332: warning: region store serial number reduced from number to number
PLS-00548: invalid use of operator.
NNL-00984: Name-to-hint translations failed: number
DRG-11102: assigned lexer can not operate on string language setting
ORA-19510: failed to set size of string blocks for file "string" (blocksize=string)
Oracle Errors 
