Thread: transaction support in pl/slql

transaction support in pl/slql

From
Justin
Date:
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.



Re: transaction support in pl/slql

From
Josh Berkus
Date:
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