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
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 19, 1999 10:03 AM
To: [EMAIL PROTECTED]
Subject: [ND] ND4.x & SQL While Loop
Hello,
I have a very simple SQL stored procedure that creates a temporary table and
inserts rows into it using a While loop. The procedure runs as expected
when
I run it manually. However, when I try to run it via ND4.1.3, it returns
zero rows. In the onAfterDataObjectExecuteEvent I check to make sure it
succeeded and it has. There are no exceptions caught either. Any
suggestions? Does ND4.x just not work with stored procs that use While
loops
and temporary tables?
Thanks in advance,
Sal
_________________________________________________________________________
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]
