Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01743: only pure functions can be indexed
- 1 Answers
- 6659 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 |
PCC-00056: FOR clause not allowed on SELECT statement at line number in file string.
PLS-00499: coercion into collection of records not supported
IMG-00899: signature cannot be generated
TNS-00064: INTCTL: Failed to find CMANAGER_NAME in INTCHG.ORA
RMAN-06124: error while looking up datafilecopy key: number
TNS-01180: Missing listener object string in Directory Server
ORA-28553: pass-through SQL: invalid bind-variable position
NNO-00702: cache checkpointing disabled
ORA-01205: not a data file - type number in header is string
NZE-29235: the key information could not be retrieved
ORA-02198: ONLINE/OFFLINE option already specified
ORA-02435: cannot disable unique(string) - unique key not defined for table
Oracle Errors 
