Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

ORA_DICT_OBJ_TYPE returns the datatype of the dictionary object changed by the event as a VARCHAR2 datatype

SQL> SQL> DECLARE   2    type1 VARCHAR2(19);   3  BEGIN   4      type1 := ora_dict_obj_type;   5      dbms_output.put_line('type1:'||type1);   6  END;   7  / type1: PL/SQL procedure successfully completed. SQL> SQL>