Re: ALTER ROLBACK ... in a procedure

Hi Jenda.
Yes you miss the abvious consideration that PL doen't permit to use DDL (like ALTER ROLLBACK or TRUNCATE TABLE) but only DML (INSERT/UPDATE).

So you can't use that statements directly. You have to turn around the language limitations. See Chapter 5 of PL/SQL User ..., about Using DDL and Dynamic SQL.

Best regards and Happy new year to all readers.

     Franco Ceotto

SIPTI srl
Via Barca II, 66
31058 Susegana (TV)
ITALY franco.ceotto_at_galactica.it

Jenda Krynicky ha scritto nel messaggio <1103_945862175_at_prague_main>...
>I am probably missing something obvious, but don't know what.
>
>I need to shrink rollback segments in a procedure, but I do not seem
>to be able to find the correct syntax. If I use this in the ISQL editor
>
> ALTER ROLLBACK SEGMENT RBS01 SHRINK;
>
>it seems to work as expected, but if I include this line in a procedure I
>get :
>
> Encountered the symbol ALTER when expecting ...
>
>
>Am I missing a keyword or what?
>
>Thanks, Jenda
>http://Jenda.Krynicky.cz
>
Received on Thu Dec 30 1999 - 05:33:24 CST