Re: Help: How do set transaction use rollback in PL/SQL

Package dbms_transaction (see $ORACLE_HOME/rdbms/admin/dbsutil.sql)

dbms_transaction.use_rollback_segment('rbs_01');

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Steve Bell wrote in message <3AD5A0AC.91D209EC_at_sympatico.ca>...


>Hi,

>

>You can issue the command dynamically...if you have 8i  you can use


>execute immediate...here's an example:

>

>create or replace procedure set_rbs

>as

>cursor i_cur is

>select ename from emp

>where length(ename) <8;

>

>b_var varchar2(60) := 'SET TRANSACTION USE ROLLBACK SEGMENT RBS6';

>

>begin

>execute immediate b_var;   - - execute your 'set' statement

>for i_rec in i_cur loop

>

>insert into testnull3

>values(I_REC.ENAME);

>end loop;

>end;

>/

>

>u518615722_at_spawnkill.ip-mobilphone.net wrote:

>

>> 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/new

>