|Subject||Re: [firebird-support] Transaction and Stored procedures.|
> This is related to the question I had. : "Rec Ver / Updates and Deletes".this ? If we
> Taking transaction into account. How does the stored procedures fit into
> take the scenario as follows.calls a stored proc and then commits.
> Client A starts a transaction and does some updates and inserts and then
> Now A gets a dead lock thanks to a other clients updates, but linked to anupdate made by client a and not the stored procedure.
>procedure inserted data into a table based on some rules)
> DOES the changes that the stored procedure make (Lets say the stored
> also roll back ? or is it outside of the transaction ? .. basically is thestored procedure in its OWN transaction and not part of the clients
>The procedure is in the clients transaction.
Database Workbench - development tool for Firebird and more!
Database development questions? Check the forum!