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

IMG-00835: merged area queue size exceeds expected size

ORA-16715: Log transport related property string of standby "string" is inconsistent.

NZE-28846: No private key

ORA-29303: user does not login as SYS

DRG-13311: USER_LEXER stored procedure name contains a semicolon

PLS-01709: value list of INSERT statement, if specified with value list rather than subquery, must be value specification

TNS-12156: TNS:tried to reset line from incorrect state

ORA-32844: exceeded maximum number of string values

NNO-00624: setting auto-refresh expiration period to number seconds

ORA-13036: Operation [string] not supported for Point Data

ORA-13504: No SYSAUX datafile clause specified

ORA-09950: Unable to get server operating system privileges

For more Oracle Errors Interview Questions Click Here