Re: Help: How do set transaction use rollback in PL/SQL
From: Paul Drake <paled_at_home.com>
Date: Thu, 12 Apr 2001 07:29:14 GMT
Message-ID: <3AD55937.E91A66BA_at_home.com>
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
>
Received on Thu Apr 12 2001 - 09:29:14 CEST
Date: Thu, 12 Apr 2001 07:29:14 GMT
Message-ID: <3AD55937.E91A66BA_at_home.com>
first statement inside of a BEGIN ... END block
BEGIN
SET TRANSACTION USE ROLLBACK SEGMENT fat_bastard
. . .
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
>
Received on Thu Apr 12 2001 - 09:29:14 CEST