somasekhar
asked on
how to get return value and cursor using ct_results() for Store procedure
I am using Sybase 15.0 version on Windows operating system. From C++ code using Sybase Client library I am executing a stored procedure.
Say this is my stored procedure that I am invoking.
create procedure abc
as
select name, sal from employee
return 1
I am using ct_results() to get the result type, For the stored procedures which are not returning any rows, Result type is coming as CS_STATUS_RESULT, but for stored procedures which are retuning me some result set eg. Mentioned abc stored procedure where select statement returns some rows, result type is always coming as CS_ROW_RESULT.
I went through the link http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.os_15.0.comlib/html/comlib/X31916.htm
After searching for ct_result, I found some sample code; I could not get much help from there.
Can anyone please let me know using Sybase client library, how I can get return value from a stored procedure returning some rows?
Say this is my stored procedure that I am invoking.
create procedure abc
as
select name, sal from employee
return 1
I am using ct_results() to get the result type, For the stored procedures which are not returning any rows, Result type is coming as CS_STATUS_RESULT, but for stored procedures which are retuning me some result set eg. Mentioned abc stored procedure where select statement returns some rows, result type is always coming as CS_ROW_RESULT.
I went through the link http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.os_15.0.comlib/html/comlib/X31916.htm
After searching for ct_result, I found some sample code; I could not get much help from there.
Can anyone please let me know using Sybase client library, how I can get return value from a stored procedure returning some rows?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.