Re: Starup trigger doesn't work

From: astalavista <nobody_at_nowhere.com>
Date: Sat, 20 Sep 2008 17:43:59 +0200
Message-ID: <48d51a3c$0$18219$426a74cc@news.free.fr>


OK thanks

"Mark D Powell" <Mark.Powell_at_eds.com> a écrit dans le message de news: 8dfe7cc1-a7ae-4888-a929-61506f3f96e8_at_y38g2000hsy.googlegroups.com... 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:43:59 CDT

Original text of this message