Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_TRANSACTION.USE_ROLLBACK_SEGMENT question
Mark,
I think I have something wrong in my procedure. I am using Forms 4.5 and have a button with when-button-pressed trigger:
DBMS_TRANSACTION.USE_ROLLBACK_SEGMENT('invalid_rollback_segment');
when I press this button, no error message return. However, when I add exception handler, error message return.
Thanks for your help.
David
mark.powell_at_eds.com (Mark D Powell) wrote in message news:<178d2795.0111070927.4c7b1f25_at_posting.google.com>...
> mail_for_deja_at_yahoo.com (Anonymous) wrote in message news:<8ee5d7c9.0111062339.6485c45_at_posting.google.com>...
> > Hi all,
> >
> > I am using DBMS_TRANSACTION.USE_ROLLBACK_SEGMENT to assign a
> > particular rollback segment for a transaction. However, I found that
> > even I specify a non-exist rollback segment to this function, there is
> > no error message return. How can I check whether the rollback segment
> > passed to this function is a valid rollback segment?
> >
> > Thanks,
> > David
>
> David, how are you calling this Oracle provided package procedure?
> What version of Oracle are you running against?
>
> Observe (version 8.1.7.2):
> UT1> @test1
> UT1> set echo on
> UT1> set serveroutput on
> UT1> declare
> 2 v_rc number := 0 ;
> 3 begin
> 4 DBMS_TRANSACTION.USE_ROLLBACK_SEGMENT('ROLL01');
> 5 v_rc := SQLCODE ;
> 6 dbms_output.put_line('The Return Code was '||v_rc);
> 7 end;
> 8 /
> The Return Code was 0
>
> PL/SQL procedure successfully completed.
>
> UT1> rollback;
>
> Rollback complete.
>
> UT1> @test1
> UT1> set echo on
> UT1> set serveroutput on
> UT1> declare
> 2 v_rc number := 0 ;
> 3 begin
> 4 DBMS_TRANSACTION.USE_ROLLBACK_SEGMENT('ROLL51');
> 5 v_rc := SQLCODE ;
> 6 dbms_output.put_line('The Return Code was '||v_rc);
> 7 end;
> 8 /
> declare
> *
> ERROR at line 1:
> ORA-01534: rollback segment 'ROLL51' doesn't exist
> ORA-06512: at "SYS.DBMS_TRANSACTION", line 65
> ORA-06512: at line 4
>
> If would appear to me that Oracle does issue an error, which I could
> trap and use to make a decission from.
>
> -- Mark D Powell --
Received on Thu Nov 08 2001 - 19:07:27 CST