Re: Rollback Transactions in a Package

That will work. In general you want to control the transaction boundaries in the application, but you can do it in a procedure in a package. Jim
"April" <privatebenjamin_at_hushmail.com> wrote in message news:21e9f79.0204051155.67ff0f5b_at_posting.google.com...
> I am a little familiar with error handling in both Oracle and more so
> with MSAccess97 (the calling application)
>
> let me fill in some more details...
>
> say I am calling stored functions / procedures from an Access97
> application. If the function doesn't return the value I want, or the
> function fails or generates an error, I would like to roll back all
> the previous functions that were called and may have run successfully.
> If all was being done in Access then I would wrap the code segment in
> a transaction to roll everything back.
>
> I was thinking that perhaps I would put all the functions in a package
> and then call the package... I guess I would have to create a
> procedure in the package that ran all the functions/procedures in the
> package and then rolled them all back on the server if there was a
> problem.
>
> I think I will try this approach. I was wondering if it was the proper
> approach.
>
> Thanks,
> April
> "Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message
 news:<T39r8.170700$ZR2.86041_at_rwcrnsc52.ops.asp.att.net>...
> > Yes, it is possible.
> > Call each function or procedure from where ever you are calling them
 from
> > and if you get an error issue :
> > rollback;
> >
> > I would look in the pl/sql documentation (application developer's guide)
 and
> > read about error handling.
> > have you looked up the documentation on otn.oracle.com? You will need
 to
> > sign up but sign up is free.
> > Jim
> > "April" <privatebenjamin_at_hushmail.com> wrote in message
> > news:21e9f79.0204041257.701dc0c6_at_posting.google.com...
> > > Is it possible to call a Package and run every function or procedure
> > > in the package and roll everything back if there is an error?
> > >
> > > If so, How would I do this?
> > >
> > > Thanks,
> > > April
Received on Sat Apr 06 2002 - 07:24:16 CEST