Jeff,

thanks for yoru advise but in this particular situation, the users want to disable the trigger.


Jovery,

Thanks for the advise but the code is not quite working yet.

when I declare SQL_CODE, can I declare it as


sql_code varchar2(100); ??????


B/c the code won't compile if you don't declare