Re: -- Alter trigger not working in script

avanrossem_at_hotmail.com (Andre) wrote in message news:<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

Andre, were you the owner when you ran the script that failed? How about when you ran the one that worked?

It would have been nice to see actual script output or error messages rather than just hazard a guess you are not the trigger owner and have to qualify the statements.

HTH -- Mark D Powell -- Received on Thu Mar 27 2003 - 02:17:40 CET