Re: ALTER ROLBACK ... in a procedure

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Wed, 22 Dec 1999 12:41:07 +0100
Message-ID: <83qdck$14or$1@news5.isdnet.net>

You have to use dbms_sql package:

cid integer := dbms_sql.open_cursor;
...
dbms_sql.parse(cid, 'ALTER ROLLBACK SEGMENT RBS01 SHRINK', dbms_sql.native); dbms_sql.close_cursor(cid);

--
Have a nice day
Michel

Jenda Krynicky <Jenda_at_Krynicky.cz> a écrit dans le message : 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 Wed Dec 22 1999 - 05:41:07 CST