Home » Developer & Programmer » Forms » Using SAVEPOINT in Forms
Using SAVEPOINT in Forms [message #361056] Mon, 24 November 2008 23:44 Go to next message
2107JPN
Messages: 1
Registered: November 2008
Junior Member
Good day.

I'm confused with the error generated.
<STEP_ONE: ORA-01086 savepoint 'Proc1_SP' never established>
Will somebody pls explain. Thanks in advance.

I have 3 program units, one calling another.
I have a button that runs Proc1. Then while running Proc3
an error is generated and the message "'Proc3 Error!!!"
is displayed. After I click on OK, the ORA-01086 error is
then displayed.

Here's a how each is basically declared.
===============================
Proc1
SP_NM varchar2(10) := 'Proc1_SP';
Begin
ISSUE_SAVEPOINT(SP_NM);
:
proc2;
:
Exception
When others then
ISSUE_ROLLBACK(SP_NM);
MESSAGE('STEP_ONE: '||DBMS_ERROR_TEXT);
RAISE FORM_TRIGGER_FAILURE;
End;
================================

===============================
Proc2
SP_NM varchar2(10) := 'Proc2_SP';
Begin
ISSUE_SAVEPOINT(SP_NM);
:
proc3;
:
Exception
When others then
ISSUE_ROLLBACK(SP_NM);
MESSAGE('STEP_TWO: '||DBMS_ERROR_TEXT);
RAISE FORM_TRIGGER_FAILURE;
End;
================================

===============================
Proc3
Begin
:
:
Exception
When others then
MESSAGE('Proc3 Error!!!');
RAISE FORM_TRIGGER_FAILURE;
End;
================================

Re: Using SAVEPOINT in Forms [message #361086 is a reply to message #361056] Tue, 25 November 2008 00:33 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please review Forms Help documentation which includes "ISSUE_ROLLBACK Restrictions: Results are unpredictable when ISSUE_ROLLBACK is used outside an On-Rollback trigger or when used with a savepoint other than that provided by a call to GET_APPLICATION_PROPERTY(SAVEPOINT_NAME)."

David
Previous Topic: how insert voice in form
Next Topic: Exception in Webutil
Goto Forum:
  


Current Time: Mon Dec 05 19:09:00 CST 2016

Total time taken to generate the page: 0.06393 seconds