Re: exception

I checked it myself, it is not correct , rollback would be for all statements , not only last one when exception happends in the procedure. <sybrandb_at_yahoo.com> wrote in message news:a1d154f4.0308212327.94fa993_at_posting.google.com...
> "Julia Sats" <julia.sats_at_sympatico.ca> wrote in message
 news:<mMd1b.659$PJ2.100455_at_news20.bellglobal.com>...
> > Hi,
> >
> > If I run my own exception at PL/SQL procedure do I need to do rollback
> > or it would be done for me by system?
> >
> > I mean nothing would be saved anyway if error happens , even if I
> > inicialize that error?
> >
> > Thanks
>
> You'll get statement level rollback, as usual.
> This means if the last statement fails, only the last statement will
> be rolled back. A subsequent explicit or implicit commit will commit
> all the other statements.
> If you want to rollback the complete transaction, you'll need to code
> the word 'rollback' in your transaction
>
> Sybrand Bakker
> Senior Oracle DBA
Received on Mon Aug 25 2003 - 02:36:28 CEST