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

TNS-01016: change_password [<listener_name>]: changes the password of the listener

ORA-39037: Object type path not supported for string metadata filter.

ORA-34871: (PERMIT06) Session-only value 'value' of workspace object has been deleted because a PERMIT change has revealed a duplicate value.

ORA-32737: Hang analysis aborted due to failed memory allocation

ORA-29845: indextype does not support local domain index on string partitioned table

RMAN-06454: duplexed backups require Enterprise Edition

RMAN-06021: FROM DATAFILECCOPY/BACKUPSET may not be specified with archive logs

ORA-08233: smsdes: cannot unmap SGA

ORA-36682: (XSDPART20) Partition name string appears twice.

ORA-22933: cannot change object with type or table dependents

ORA-12810: PARALLEL_MAX_SERVERS must be less than or equal to string

ORA-01628: max # extents (string) reached for rollback segment string

For more Oracle Errors Interview Questions Click Here