Subject Transaction and Stored procedures.
Author Johannes Pretorius
Good day

This is related to the question I had. : "Rec Ver / Updates and Deletes".

Taking transaction into account. How does the stored procedures fit into this ? If we
take the scenario as follows.

Client A starts a transaction and does some updates and inserts and then calls a stored proc and then commits.
Now A gets a dead lock thanks to a other clients updates, but linked to an update made by client a and not the stored procedure.

DOES the changes that the stored procedure make (Lets say the stored procedure inserted data into a table based on some rules)
also roll back ? or is it outside of the transaction ? .. basically is the stored procedure in its OWN transaction and not part of the clients transaction ?

I hope I make sense. English is bad today,

Thanks in Advance

Johannes Pretorius
(Programeerings Departement- Promed)

Tel : +27 11 607-3300
Faks : +27 11 622-6939
webtuiste :

This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you are not the intended recipient, any review, re transmission,
disclosure, copying, modification or other use of this email message or
attachments is strictly forbidden. If you receive this email message in
error, please contact the author and delete the message and any
associated files from your computer. Also the contents of this e-mail
is considered confidential.
Thank you