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-31194: Resource string is already deleted

RMAN-08008: channel string: starting full datafile backupset

NNL-00915: Authority required on server queries: string

ORA-22807: cannot resolve to a scalar type or a collection type

CLSR-00522: Resource string is not registered

ORA-32405: cannot alter tablespace for existing materialized view log

ORA-37082: Invalid percent

LPX-00283: document encoding is ~s-based but default input encoding is not

ORA-01560: LIKE pattern contains partial or illegal character

ORA-13783: invalid tuning scope

ORA-09322: slpdtb: unable to convert packed decimal to binary

ORA-31116: Tablespace not specified correctly

For more Oracle Errors Interview Questions Click Here