Re: Help: How do set transaction use rollback in PL/SQL
Date: Thu, 12 Apr 2001 12:46:16 GMT
Message-ID: <3AD5A0AC.91D209EC_at_sympatico.ca>
Hi,
[Quoted] 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
Received on Thu Apr 12 2001 - 14:46:16 CEST