-- Alter trigger not working in script

From: Andre <avanrossem_at_hotmail.com>
Date: 26 Mar 2003 04:47:56 -0800
Message-ID: <4d32d1be.0303260447.7316a97c_at_posting.google.com>


Hello all,

I have a sql-script in which some triggers has to be disabled first to proceed.
In sqlPlus I do NOT see that the triggers are disabled. I suspect a "Trigger altered." statement. Also the sql-script doesn't work because the triggers are NOT disabled.
When I try the script on another machine everything is working. (I do see the "Trigger altered." statement)

Here are the first two lines of the script:

alter trigger IU_a disable;
alter trigger IU_B disable;

What can be the problem???

Thanks for all suggestions, and kind regards, Andre Received on Wed Mar 26 2003 - 13:47:56 CET

Original text of this message