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-26696: no streams data dictionary for object with number string and version number string from source database string

ORA-39027: wrong version of master table

QSM-01039: selection present on right hand side of an outer join

ORA-12091: cannot online redefine table "string"."string" with materialized views

TNS-12595: TNS:no confirmation

TNS-01057: Program name: string

ORA-02096: specified initialization parameter is not modifiable with this option

ORA-09786: sllfop: open error, unable to open file.

RMAN-08500: channel string: sid=string devtype=string

PCC-02354: A file included with #include may not contain SQL statements

PLS-01418: Subquery cannot include set operators in ANSI's grammar

ORA-01923: CASCADE aborted, objects locked by another user

For more Oracle Errors Interview Questions Click Here