dbTalk Databases Forums  

Getting Result from Stored Procedure using ct-libraries.

comp.databases.sybase comp.databases.sybase


Discuss Getting Result from Stored Procedure using ct-libraries. in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Amol Natekar
 
Posts: n/a

Default Getting Result from Stored Procedure using ct-libraries. - 06-04-2004 , 08:29 AM






Hi all,

I am programming Sybase using ct-library.

I am trying to execute a stored procedure named "sp_sysmon 1"
using the ct-library. But I'm not able to capture the result set of
that procedure.
While monitoring the traffic it is shown that the procedure is
executed properly and the result set arrives at the client side
perfectly. But the library routine calls are not able to fetch them.
I'm just able to get the final status result of that procedure.

Is there any way to fetch the result set properly?


Thanks.
Amol

Reply With Quote
  #2  
Old   
Michael Peppler
 
Posts: n/a

Default Re: Getting Result from Stored Procedure using ct-libraries. - 06-04-2004 , 09:33 AM






On Fri, 04 Jun 2004 06:29:13 -0700, Amol Natekar wrote:

Quote:
Hi all,

I am programming Sybase using ct-library.

I am trying to execute a stored procedure named "sp_sysmon 1"
using the ct-library. But I'm not able to capture the result set of that
procedure.
While monitoring the traffic it is shown that the procedure is
executed properly and the result set arrives at the client side perfectly.
But the library routine calls are not able to fetch them. I'm just able to
get the final status result of that procedure.
Most of the output from this proc is in the form of PRINT statements.
These are sent to the server callback (see ct_callback()) with an error
number of 0.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.