Prevents Oracle Database from dropping and reacquiring compiler switch settings. With this clause, Oracle preserves the existing settings and uses them for the recompilation of any parameters for which values are not specified elsewhere in this statement.
ALTER TRIGGER oe.get_bal COMPILE REUSE SETTINGS
No comments:
Post a Comment