Xref: alice comp.databases.oracle.tools:17954 Path: alice!news-feed.fnsi.net!news.ridgecrest.ca.us!news-out.cwix.com!news-out.CW.net!newsfeed.cwix.com!194.72.7.126!btnet-peer!btnet!neptunium.btinternet.com!not-for-mail From: "Richard Platt" Newsgroups: comp.databases.oracle.tools Subject: Re: FORMS 5. Call_FORM help Date: Wed, 28 Oct 1998 23:59:34 -0000 Organization: BT Internet Lines: 64 Message-ID: <718b7i$gm$1@plutonium.btinternet.com> References: <714n72$i70$1@nnrp1.dejanews.com> <3635F3F0.3903249B@earthlink.net> <715usr$l4f$1@apache.dtcc.edu> X-Newsreader: Microsoft Outlook Express 4.72.3110.1 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Joe Are you sure about that. It would be wonder to me that a commit in the form didn't commit ever change in the users session !! Richard Platt Joe Brown wrote in message <715usr$l4f$1@apache.dtcc.edu>... >When using dml in procedures/triggers in forms use > >forms_ddl('commit'); > >to issue a commit. Forms_commit built-in only commits blocks of the >form, not implicit cursors in procedures/triggers. > > >In article <3635F3F0.3903249B@earthlink.net>, >Ashok Upadhyay wrote: >>Is call form necessary there? If that runs procedures only without any user >>inputs, that can be changed to forms/stored procedures and could be called from >>calling form itself. >> >>Commit_Form or Commit /rollback in procedures should release the LOCK. Is commit >>present in procedures? Or use COMMIT_FORM in called form to release the lock. >> >>Thanks >> >>mdesouza@YAHOO.COM wrote: >> >>> Hi >>> >>> I have a main form which calls another forms that runs a few procedures to >>> perform update deletes and inserts on a table >>> >>> when the procedure completes, the locks on the table have not been released, >>> the only way the locks are released on that table is when I exit all the forms >>> >>> Can someone explain why , or is there way round this so that when the >>> procedures complete the locks are released >>> >>> regards >>> >>> michael dsouza >>> >>> -----------== Posted via Deja News, The Discussion Network ==---------- >>> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own >> > > >-- >(: Joe Brown :) joe@apache.dtcc.edu >I believe Wine is going to be great if it ever gets finished. . . >I believe Linux _is_ great even though it's not finished! ! ! >I believe you have my address. :-)