"Julia Sats" <ju********@sympatico.ca> wrote in message news:<mM******************@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