ALTER ROLBACK ... in a procedure

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:29:35 CST