Hi Sal,
OK, that is what I guessed you would be doing.
I can't imagine ND anyway influencing or being influenced by what happens
inside a stored procedure. It would be simply impossible, in spite of all
the miracles that ND is capable of doing.
I would suspect something going wrong with the passing of input parameters,
if any, which might be affecting the stored procedure result.
Aby
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 19, 1999 10:34 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [ND] ND4.x & SQL While Loop
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]
_________________________________________________________________________
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]
