OraFAQ Forum: Forms » Oracle Form Partial Commit

Home » Developer & Programmer » Forms » Oracle Form Partial Commit

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Form Partial Commit [message #87427]

Mon, 03 January 2005 16:35

skc
Messages: 14
Registered: September 2004

Junior Member

Does Oracle Form 6.0 supports partial commit? i.e. is it possible to commit Data Block A but not Data Block B? It is possible to do so by segregating 2 Data Block into 2 different Form, and as 2 Forms holds different sessions, partial commit on either Block A or B can be done. It can be done also by calling a store pro with SET TRANSACTION keywords... but is there the third way, or a quicker or easier way?

Report message to a moderator

Re: Oracle Form Partial Commit [message #87432 is a reply to message #87427]

Mon, 03 January 2005 22:31

Himanshu
Messages: 457
Registered: December 2001

Senior Member

Yes,
Make use of On-insert,On-update or On-delete triggers.

HTH
Regards
Himanshu

Report message to a moderator

Previous Topic:	leading zero in STD code or MOBILE NO.
Next Topic:	Execute_Query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 17:06:07 CDT 2024