Re: Starup trigger doesn't work
From: gym dot scuba dot kennedy at gmail <kennedyii_at_verizon.net>
Date: Sat, 20 Sep 2008 06:49:54 GMT
Message-ID: <m21Bk.495$MN3.41@nwrddc01.gnilink.net>
Date: Sat, 20 Sep 2008 06:49:54 GMT
Message-ID: <m21Bk.495$MN3.41@nwrddc01.gnilink.net>
"astalavista" <nobody_at_nowhere.com> wrote in message
news:48d4992f$0$30999$426a74cc_at_news.free.fr...
> Hi,
>
> I created a startup on database trigger
>
> to activate the outline at startup but it doesn't work
>
> do you know why ? (Oracle 9.2.0.4 on windows)
>
> Thanks in advance
>
>
>
> CREATE OR REPLACE TRIGGER valid_outlines_default
>
> after startup on database
>
> begin
>
> execute immediate 'alter system set use_stored_outlines=DEFAULT;';
>
> end;
>
>
I believe you do not need the ; inside the execute immediate.
Jim
Received on Sat Sep 20 2008 - 01:49:54 CDT