-- 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>
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