Aby,
The Oracle version of a procedure returning a result set is a function
returning an open cursor. This has always worked for a PL/SQL client, not
JDBC.
I have heard that using JDBC and Oracle 8i enterprise edition it is possible
for this to work. There are some limitations.
The TYPE of the cursor must be a global type, not a type local to a package.
Of course this will not work with the ND spider API.
I have not tried it myself because I don't have this version of Oracle, but
it is described in the Oracle docs.
Brendan
TeamND
-----Original Message-----
From: Aby Mathew
To: 'Rajneesh Garg';
[EMAIL PROTECTED]; ND News Group
Sent: 11/22/99 11:44 AM
Subject: Re: [ND] How to : ND5, Oracle 8i and Stored Procedures
I haven't worked on the configuration in question, but does Oracle
Stored
procedure return any result set?
>From what I know the only way you can get something out of an Oralce
stored
procedure is as a OUT or IN OUT parameter.
Aby
TeamND
> -----Original Message-----
> From: Rajneesh Garg [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 19, 1999 9:38 PM
> To:
> [EMAIL PROTECTED];
> [EMAIL PROTECTED];
> [EMAIL PROTECTED];
> [EMAIL PROTECTED];
> [EMAIL PROTECTED];
> [EMAIL PROTECTED]; ND News
> Group; ND Forums 2; ND Forums
> Subject: [ND] How to : ND5, Oracle 8i and Stored Procedures
>
>
> Hi there!
>
> I am working on ND 5.0 with Oracle 8i as the database. We
> want to use the
> stored procedures in our work. However, we have not been able
> to do. CAn
> somebody please guide us how to use Stored Procedures in ND 5 with an
> example. We require the resultset from the Stored Procedure.
> We want to sent
> upto 4 parameters in the Stored Procedure.
> Thanx.
>
> Rajneesh Garg mailto:[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]
>
________________________________________________________________________
_
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]
