transaction support in pl/slql

Started by Justinalmost 18 years ago2 messages
#1Justin
justin@emproshunts.com

i have a request ??

Is there any intension of expanding Transaction support into PL/SQL.
this would simplify GUI/client code to know the if a function failed it
roll back the transaction. right now i have to pass back some kind
error message that i look for to see if the transaction failed to
either run the commit or rollback command

i know about raise exception within sub blocks but i want a way to
roll back to the starting transaction.

#2Josh Berkus
josh@agliodbs.com
In reply to: Justin (#1)
Re: transaction support in pl/slql

Justin wrote:

i have a request ??

Is there any intension of expanding Transaction support into PL/SQL.
this would simplify GUI/client code to know the if a function failed it
roll back the transaction. right now i have to pass back some kind
error message that i look for to see if the transaction failed to

See "Autonomous Transactions" in the TODO list.

--Josh