Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01743: only pure functions can be indexed
- 1 Answers
- 6584 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-02262: ORA-string occurs while type-checking column default value expression
ORA-02785: Invalid shared memory buffer size
KUP-04069: error fetching data for external table
ORA-12198: TNS:could not find path to destination
ORA-00445: background process "string" did not start after string seconds
RMAN-08072: deleted controlfile copy
TNS-12689: Server Authentication required, but not supported
ORA-01169: DATAFILE number 1 not found. Must be present
ORA-07681: sou2os: An error occurred while initializing Oracle
ORA-22874: attribute "string" is not part of the type "string"
ORA-13751: "SQL Tuning Set" "string" does not exist or user "string" is not the owner of the "SQL Tuning Set".
ORA-30189: reserved for future use
Oracle Errors 
