From 10g docs "The following CREATE statements are obfuscated: CREATE [OR REPLACE] FUNCTION function_name CREATE [OR REPLACE] PROCEDURE procedure_name CREATE [OR REPLACE] PACKAGE package_name CREATE [OR REPLACE] PACKAGE BODY package_name CREATE [OR REPLACE] TYPE type_name AS OBJECT CREATE [OR REPLACE] TYPE type_name UNDER type_name CREATE [OR REPLACE] TYPE BODY type_name Note: The CREATE [OR REPLACE] TRIGGER statement, and BEGIN..END anonymous blocks, are not obfuscated." Although you can call a [packaged] procedure from trigger as already said. > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] > On Behalf Of rjamya >=20 > In 9i instead of writing your trigger code you can call a procedure > instead, and _that_ could be wrapped. Now sure of trigger code though > ... >=20 > Raj >=20 -- //www.freelists.org/webpage/oracle-l