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-06304: IPA: Message receive error

ORA-38763: flashback not started; enabled threads have changed

ORA-14059: partition "string": INITRANS value must be less than MAXTRANS value

ORA-09771: osnmwrtbrkmsg: bad return code from msg_send.

SQL*Loader-00645: error converting character length field to a number

ORA-35095: (QFSVNS01) One or more imported values of fixed-width dimension workspace object have been truncated.

PLS-00124: name of exception expected for first arg in exception_init pragma

RMAN-06036: datafile number is already restored to file string

RMAN-08002: starting full resync of recovery catalog

ORA-06807: TLI Driver: could not open ethernet device driver file

ORA-09809: Unable to get user's group ID from connection

ORA-31087: insufficient privileges to delete schema "string"

For more Oracle Errors Interview Questions Click Here