Re: Starup trigger doesn't work

On Sep 20, 2:49 am, "gym dot scuba dot kennedy at gmail" <kenned..._at_verizon.net> wrote:
> "astalavista" <nob..._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- Hide quoted text -
>
> - Show quoted text -

Actually not only is the semicolon inside the SQL statement not necessary the manual specifically states not to include it:
>>

When constructing a single SQL statement in a dynamic string, do not include a semicolon (;) at the end inside the quotation mark <<

From topic Using the EXECUTE IMMEDIATE Statement in PL/SQL, found in Ch 7 Performing SQL Operations with Native Dynamic SQL, in the Oracle® Database PL/SQL User's Guide and Reference 10g Release 2 (10.2) Part Number B14261-01.

HTH -- Mark D Powell -- Received on Sat Sep 20 2008 - 10:33:40 CDT