Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-01743: only pure functions can be indexed



ORA-01743: only pure functions can be indexed..

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

Post New Answer

More Oracle Errors Interview Questions

NNL-00217: Controller is sleeping for number seconds

1 Answers  


DRG-12509: length of the stop word string exceeded the limit of string bytes

1 Answers  


ORA-12202: TNS:internal navigation error

1 Answers  


ORA-00292: parallel recovery feature not installed

1 Answers  


ORA-13148: failed to generate SQL filter

1 Answers  






ORA-26006: Incorrect bind variable in column string's sql expression - string

1 Answers  


SQL*Loader-00600: Bind size of number bytes increased to number bytes to hold 1 row.

1 Answers  


IMG-00515: incorrect number of input channels

1 Answers  


ORA-01568: cannot set space quota on PUBLIC

1 Answers  


ORA-00291: numeric value required for PARALLEL option

1 Answers  


ORA-31213: DBMS_LDAP: PL/SQL - Invalid LDAP mod option.

1 Answers  


ORA-24374: define not done before fetch or execute and fetch

2 Answers  






Categories