| Using SAVEPOINT in Forms [message #361056] |
Mon, 24 November 2008 23:44  |
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  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
