On 08/28/2014 04:22 AM, Ramesh T wrote:
> OK.. i created a function for delete customer from different tables in
> single database.
>
> i want rollback..
>
> my question:
> where i need to place rollback ,with in a
> function along with deletion statements..? or after run the function ..?
> i do not need commit..
Realized in my last post the below was not entirely clear:
"If you want to invoke an explicit ROLLBACK then you will need an
explicit BEGIN, which means you will need an explicit COMMIT to have the
operation succeed. "
should have been:
If you want to invoke an explicit ROLLBACK when you have a error then
you will need an explicit BEGIN, which means you will need an explicit
COMMIT when the operation succeeds in order for the transaction to
complete.
> please let me know..
--
Adrian Klaver
adrian.klaver@aklaver.com