Home » Developer & Programmer » Forms » Parent form should commit or rollback regardless of child form (Forms 10G)
Parent form should commit or rollback regardless of child form [message #403427] Fri, 15 May 2009 09:34 Go to next message
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 #403432 is a reply to message #403427] Fri, 15 May 2009 09:59 Go to previous messageGo to next message
TonyJaa
Messages: 50
Registered: May 2009
Member
hi,

Use OPEN_FORM with parameter SESSION.

Re: Parent form should commit or rollback regardless of child form [message #403668 is a reply to message #403427] Mon, 18 May 2009 00:24 Go to previous messageGo to next message
gurupatham
Messages: 66
Registered: March 2008
Location: Chennai
Member
I should not connect new session . Since it is a exist application , it might create many problem.

Anyother way to handle this kind of scenario?
Re: Parent form should commit or rollback regardless of child form [message #403903 is a reply to message #403668] Tue, 19 May 2009 08:39 Go to previous messageGo to next message
Utsavwalia
Messages: 1
Registered: May 2009
Junior Member
Well you don't have to use session. Just use open_form

Regards,
Utsav.
Re: Parent form should commit or rollback regardless of child form [message #403908 is a reply to message #403903] Tue, 19 May 2009 08:45 Go to previous messageGo to next message
gurupatham
Messages: 66
Registered: March 2008
Location: Chennai
Member
Still , Parent form gets committed. any other way?
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 Go to previous message
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.
Previous Topic: forms deployment issue for vista
Next Topic: knowing the path of word automaticly
Goto Forum:
  


Current Time: Fri Dec 02 22:52:22 CST 2016

Total time taken to generate the page: 0.21944 seconds