Re: COMMIT;

Posted in 1998

Bill Ennis — Thu, 26 Mar 1998 23:05:57 -0600 — source: Informix-list mailing list archive (1991-1998)

The commit will effect all actions within that database session. You can avoid it by opening an independent connection for the stored procedure call. -Bill PRAVEEN MOHANAN wrote: > Hi..Users.... > I have a doubt. I am using oracle 7.23. I have procedure > which does some transactions. This procedure in turn call another > function. The function returns a unique number from a table. I have used > commit stmt in the function. > Now.. the question is will that commit , effect the calling procedure? > If so, how to avoid it?. > > Regards. > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com