Re: Auto-Commits in Stored Procedures?

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Fri, 5 Mar 1999 16:26:01 +0100
Message-ID: <36dff78a$0$4896@pascal>

Douglas Whitacre wrote
>I thought that by default if you don't explicitly perform a
>commit in a stored procedure that it would
>rollback any changes made to the tables.

No, why should it? Still, if *you* execute a rollback, then the changes made by your stored procedure will be undone as well.

Arjan. Received on Fri Mar 05 1999 - 09:26:01 CST

This message: [ Message body ]
Next message: kevon_at_my-dejanews.com: "substituting a space for a NULL"
Previous message: Nuno Guerreiro: "Re: Sqlloader problems!"
In reply to: Douglas Whitacre: "Auto-Commits in Stored Procedures?"
Next in thread: Mike Burden: "Re: Auto-Commits in Stored Procedures?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US