Stored proc,cursor return,C++ Builder or ODBC
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