ORA-30357: this PL/SQL function cannot be supported for query rewrite

ORA-30357: this PL/SQL function cannot be supported for
query rewrite

Question Posted / guest

ORA-30357: this PL/SQL function cannot be supported for query rewrite..

Answer / guest

Cause: The statement referenced a PL/SQL function that is
not marked DETERMINISTIC.

Is This Answer Correct ?

0 Yes

0 No

More Oracle Errors Interview Questions

ORA-07615: $CHANGE_CLASS failed in retrieving the specified file label

ORA-19649: offline-range record recid string stamp string not found in file string

NNL-00205: Reload check occurs in string

ORA-16128: User initiated shut down successfully completed

ORA-24777: use of non-migratable database link not allowed

NNF-01004: DCE returned unspecified error string

ORA-14136: ALTER TABLE EXCHANGE restricted by fine-grained security

ORA-27024: skgfqsbi: sbtinit2 returned error

ORA-00100: no data found

ORA-01531: a database already open by the instance

ORA-29661: Unable to find the superclass of the defined in the EXTERNAL NAME

DRG-11877: This Cache Version Has Expired And Will Be Automatically Reloaded

For more Oracle Errors Interview Questions Click Here