Oracle DBMS_CROSSEDITION_TRIGGER
Version 11.2.0.1
 
General Information
Purpose Supports Crossedition Triggers. Dropped from 11.2.0.2 onward.
Source {ORACLE_HOME}/rdbms/admin/dbmscet.sql
First Available 11.2
Constants
Name Data Type Value
is_applying BOOLEAN FALSE
Dependencies
DBMS_SQL DBMS_SYS_SQL
Security Model Execute is granted to PUBLIC
 
IS_APPLYING
Enable / disable cross-edition triggers dbms_crossedition_trigger.is_applying RETURN BOOLEAN;
set serveroutput on

BEGIN
  IF dbms_crossedition_trigger.is_applying THEN
    dbms_output.put_line('TRUE');
  ELSE
    dbms_output.put_line('FALSE');
  END IF;
END;
/
 
 
Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2013 Daniel A. Morgan All Rights Reserved