Details:
Database being used : Oracle 8.0.4
1. There is a stored procedure in the database which accepts a cursor variable as
' IN OUT ' parameter, and fills in the values of the different fields in to this
cursor variable. The procedure is given below.
create or replace package cv as
TYPE vCsr is REF CURSOR;
END cv;
create or replace procedure cvxyz (xyz_cv IN OUT cv.vCsr) AS
BEGIN
OPEN xyz_cv FOR SELECT * FROM XYZ;
END cvxyz;
END cv;
We have created a data object derived from CSpProcedure which points to the above
mentioned procedure, but ND is not able to understand what is the data type given
in the procedure as IN OUT parameter.
How this procedure could be invoked from the ND and how the values filled in the
IN OUT parameter can be accessed in ND???? What is the data type which is equivalent
to cursor variable in ND which could be passed in to the procedure derived class
object???
If this is not possible, what are the other ways to get more than one records from
database using procedures(using CSpProcedure class)???
We would be grateful if you can get back to us as early as possible.
The Example given in the documentation of CSpProcedure doesn't say anything about the
procedure written in the database, the Datatype of the parameters.
Thanking you in anticipation.
_________________________________________________________________________
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]
