Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01743: only pure functions can be indexed
- 1 Answers
- 6734 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 |
NZE-28761: element creation failure
ORA-06431: ssaio: Invalid Block number
ORA-38483: invalid FUNCTION/PACKAGE/TYPE name: "string"
ORA-22897: no scope clause specified for user-defined REF column "string"
ORA-15110: no diskgroups mounted
ORA-33100: (APABBR02) Value 'number' is not valid for the workspace object option.
QSM-01016: Query rewrite does not support, aggregate, string
ORA-13271: error allocating memory for geometry object
PCC-02306: illegal name of C function
ORA-37129: (XSCCOMP04) The AGGMAP workspace object cannot be used to aggregate the VARIABLE workspace object. All static MODEL statements must precede all RELATION statments over the bases of the COMPRESSED COMPOSITE.
QSM-00767: a SQL cache is not available to user string
ORA-39039: Schema expression "string" contains no valid schemas.
Oracle Errors 
