I have a stored proc that inserts a record into a table and sets three output parameter values. There is a contition that then inserts a record into a second table. If this insert does not occur, my calling application gets the output values, but if the conditional insert does occur, the output values are empty. Can anyone tell me why? Here is the code:

CREATE Procedure usp_IMDetails_I nsertTempDtl
@Orht_Id int,
...

I have written a stored proc to write order details to the db. If there is additional description text, I am writting it out to another note table. i initially performed this using EXEC with another stored proc. When doing this, upon returning to my VB.Net app, the @Ordt_Id, @PDT_ProductSKU , and the @Pdt_ProdDesc variables no longer contain any data. I moved the note creation code into this stored proc, but I get the same results. If there is...