Re: COMMIT;

Hi Shashi, In article <6g4d1r$oh3@camel15.mindspring.com>, "John Smith" <abc@123.com> wrote: > > The Oracle part is your first problem. > I agree with John's assesment :-) However, since you have posted this to c.d.i and if you do have Informix 7.23 and if your message had a typo. then, yes, the function which has been called from SP will commit. So, you would probably have to modify this function to accept a parameter based on which it will issue a COMMIT or not. HTH, Ravi... ------------------------------------------------------------------- > Shashi Nair wrote in message <6g0ir5$i2d$1@news.xmission.com>... > > > >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. > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading