|
|
Posted by timothy.alvis on 07/11/06 18:26
It's not so much a problem, as I don't know how to get around this
issue. We have applications that rely on the return value of a stored
procedure. This stored procedure inserts a record into a table that has
a trigger. The trigger calls a couple of stored procedures itself.
Due to the trigger, we have a return value of 0 coming in ahead of the
return value for the stored procedure we call directly. I've tested
this in Query Analyzer as well, and the same behavior applies.
In case I didn't describe it clearly:
Call storedproc1
storedproc1 inserts a record into table1
table1 has an INSERT trigger
expected behavior is: storedproc1 returns value1 and value2
actual behavior is: storedproc1 returns 0, then returns value 1 and
value 2
Navigation:
[Reply to this message]
|