Hi,
The procedure has one input parameter, creates the temp table (IE #Temp),
does a while loop which inserts into the table, and then does a Select * from
#Temp. The Select statement works great if I manually code the temp table to
have some results, but when I do the While loop, it doesn't do anything. I
can run the proc from a query screen and it returns all the expected rows.
ND seems to be having a problem with it. I am using NT SQL6.5. I don't want
to use output parameters since there are multiple records in the result set.
Any suggestions?
Thanks,
Sal
<< I don't know exactly what you are trying to do. Just by inserting rows into
a temporary table, you wouldn't expect the stored procedure to return a
result set.
Sybase and like-minded RDBMS allows a stored procedure to return result
sets. Oracle does not. The only way you can get back something from an
Oracle stored procedure is as an output parameter.
Hope this helps,
Aby >>
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
