| Parent form should commit or rollback regardless of child form [message #403427] |
Fri, 15 May 2009 09:34  |
gurupatham
Messages: 66
Registered: March 2008
Location: Chennai
|
Member |
|
|
I have an issue like ,
Say "FORM_B" is Called by "FORM_A" using CALL_FORM Statement . In Form_A , i am doing some DML statement before calling FORM_B . Data entered by user are stored in Data base by using COMMIT_FORM statement in FORM_B.
While giving the COMMIT_FORM in FORM_B , it commits the DML statement in FORM_A too.
My requirement is , it should not commit the DML statement that is created in FORM_A. ( DML statement should commit or rollback in FORM_A regardless of FORM_B ).
How to handle this situation?
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Parent form should commit or rollback regardless of child form [message #403916 is a reply to message #403908] |
Tue, 19 May 2009 09:24  |
TonyJaa
Messages: 50
Registered: May 2009
|
Member |
|
|
Oracle do not allow to commit only a part of a transaction. To perform this kind of stuff you're forced to create new transaction. This is the simplest.
If you don't want to use different transaction. Use savepoint. SAVEPOINT A when you call form B (instead of commit_form), SAVEPOINT B when you commit in Form B (instead of commit_form).
After you choose beetween rollback to A or B. but B contains the modification of A.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
