exception

[Julia Sats]

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

[sybrandb@yahoo.com]

Re: exception

"Julia Sats" <julia.sats@sym patico.ca> wrote in message news:<mMd1b.659 $PJ2.100455@new s20.bellglobal. com>...[color=blue]
> 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[/color]

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