raise_application_error/rollback

From: Harald Mitterhofer <mitt_at_pcb899.gud.siemens.at>
Date: Mon, 11 Oct 1999 17:28:46 +0200
Message-ID: <3802022E.326D201A@pcb899.gud.siemens.at>

hi!

there is a pl/sql-standard-procedure raise_application_error, which according to the application-developer-guide "terminates procedure execution, rolls back any effects of the procedure and returns a user-specified error....";

"rolls back...": does this mean, that there is an implicit rollback? some of my little test-procedures seam to prove the opposite, but i am not sure, those tests are correct;

i want to write a procedure, which has to be exactly one transaction; so far i did:
if ... then

rollback;
raise_application_error...
else

commit;
end if;

is this rollback redundant??

thanxs;
harald mitterhofer Received on Mon Oct 11 1999 - 10:28:46 CDT