i have a vb program which expects an output parameter from a store procedure.
the store contains INSERTs and UPDATEs, and in the end has a SET command for the output and then RETURN. in which case the vb recieves EMPTY . if i delete all the UPDATEs and INSERTs from the store, then the vb recieves the output value intended.
can anyone help me?
another store in the same program works fine but it does not have any commands but select.