waiman
asked on
Locate records in ORACLE cursor expression using C#/ASP.NET
Hi guys...
I have a ORACLE stored procedure that returns a recordset and cursor expression:
OPEN P_RSET FOR
SELECT CUST_ID, CURSOR( SELECT p.PRODUCT_CODE
FROM PRODUCT_TABLE p
WHERE p.CUST_ID = c.CUST_ID) products
FROM CUSTOMER _TABLE c;
Can someone tell me how can get individual record within the products cursor using C#? Should I use ORACLEDatareader/adapter? How do I declare the parameters in the code? Can I have a brief example pls. Thanks a lot
I have a ORACLE stored procedure that returns a recordset and cursor expression:
OPEN P_RSET FOR
SELECT CUST_ID, CURSOR( SELECT p.PRODUCT_CODE
FROM PRODUCT_TABLE p
WHERE p.CUST_ID = c.CUST_ID) products
FROM CUSTOMER _TABLE c;
Can someone tell me how can get individual record within the products cursor using C#? Should I use ORACLEDatareader/adapter? How do I declare the parameters in the code? Can I have a brief example pls. Thanks a lot
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
yes you should use datareader to read ;-) the data
HTH
Ivo Stoykov
HTH
Ivo Stoykov
ASKER