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-25120: MINIMUM EXTENT option already specified

NNL-01006: META VIOLATION responses received: number

PLS-00418: array bind type must match PL/SQL table row type

NID-00120: Database should be mounted exclusively

ORA-00340: IO error processing online log string of thread string

ORA-30371: column cannot define a level in more than one dimension

ORA-00437: ORACLE feature is not licensed. Contact Oracle Corp. for assistance

LFI-00118: Unable to change type to Unknown.

ORA-16598: Data Guard broker detected a mismatch in configuration.

ORA-07494: scgcm: unexpected error.

NNL-00933: Requests refused, OTHER-DATA violation: number

PCC-02107: You may not specify PARSE = FULL when CODE = CPP

For more Oracle Errors Interview Questions Click Here