ORA-30357: this PL or SQL function cannot be supported for query rewrite
Cause: The statement referenced a PL or SQL function that is not marked DETERMINISTIC.
Action: Perform one of the following actions: marked DETERMINISTIC only if it always returns the same result value for any given set of input argument values, regardless of any database state or session state. Do not mark the function as DETERMINISTIC if it has any meaningful side-effects.
Cause: The statement referenced a PL or SQL function that is not marked DETERMINISTIC.
Action: Perform one of the following actions: marked DETERMINISTIC only if it always returns the same result value for any given set of input argument values, regardless of any database state or session state. Do not mark the function as DETERMINISTIC if it has any meaningful side-effects.
No comments:
Post a Comment