Stored proc,cursor return,C++ Builder or ODBC

From: Clement <clement_at_ms.tl.gov.tw>
Date: 1998/02/20
Message-ID: <01bd3dc0$a087a020$8f56900a_at_clement>#1/1


I am using the Borland C++ Builder .I use TStoredProc Component In my code, I can bind a stored
procedures output, call the stored procedure and get the correct answer. But only if the return type is Cursor type list. This is a problem if the stored procedure returns "can't create cursor"

If anyone has any experience calling a stored procedure that returns a cursor, from C/C++ code, through C++ Builder or ODBC, I would appreciate any hints.

Following is my stored procedure in oracle7.3:

Package cv_types;
As

        TYPE IDCurType is REF CURSOR RETURN operator%ROWTYPE; End cv_types;

Procedure getIDCur
(v_opid IN OUT cv_types.IDCurType) As
Begin

         Open v_opid For Select * from hinet.operator; End GetIDCur;

In C++ Builder:

TStoredProc.Open()
This method I have tried,but it show me a dialog "Error creating cursor handle"                                 

                        Thank you! Received on Fri Feb 20 1998 - 00:00:00 CET

Original text of this message