Help: How do set transaction use rollback in PL/SQL
From: <u518615722_at_spawnkill.ip-mobilphone.net>
Date: Wed, 11 Apr 2001 19:58:59 GMT
Message-ID: <l.987019140.1107055664_at_[198.138.198.252]>
Date: Wed, 11 Apr 2001 19:58:59 GMT
Message-ID: <l.987019140.1107055664_at_[198.138.198.252]>
[Quoted] [Quoted] We have a PL/SQL running in which we use a cursor and for loop. But we can not set the rollback segment. If we put "set transaction use rollback segment RBS1", PL/SQL just ignore us. If we put the sentence inside the loop, we got an error message.
Could somebody tell me is it possible to set rollback segment for a PL/SQL?
Thanks
-- Sent by dbadba62 from hotmail subpart from com This is a spam protected message. Please answer with reference header. Posted via http://www.usenet-replayer.com/cgi/content/newReceived on Wed Apr 11 2001 - 21:58:59 CEST