June 26, 2002 at 7:07 am
I have written a SP that calls 8 other sps with the same output parameters. My calls to the sps are all syntactically correct and work individually. I insert the output parameters into a temp table and return that as a result set.
The problem I am having: the 4th sp returns the correct output however the 5, 6, 7, 8th all return the same value that the 4th sp returned. When run individually the 5,6,7 etc all return the correct output values.
I did resolve this by setting the output parameters to NULL before I made the next call that uses the same output parameter. But it seemed a strange occurrence and I just wanted to find out if anyone else has experienced this problem or if it is a known bug?
Thanks.
Tom
June 26, 2002 at 8:19 am
No bug that I know of. Could you post the code?
Andy
June 26, 2002 at 9:46 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply