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-07-2004 , 01:59 AM






Hi all,

I am programming Sybase using ct-library.

I am trying to execute a stored procedure named "sp_sysmon 1" us 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 Natekar

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

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






On Sun, 06 Jun 2004 23:59:06 -0700, Amol Natekar wrote:

Quote:
I am trying to execute a stored procedure named "sp_sysmon 1" us 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?
Most of those are generated with PRINT statements in the stored procedure.
Such messages need to be handled with a server callback. See the
ct_callback() and the CS_SRVMESSAGE_CB entries in the CTlib docs.

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
  #3  
Old   
Amol Natekar
 
Posts: n/a

Default Re: Getting Result from Stored Procedure using ct-libraries. - 06-25-2004 , 01:57 AM



Thanx Sir....
Got whatever was required...
Thanx a lot for ur reply...




Michael Peppler <mpeppler (AT) peppler (DOT) org> wrote

Quote:
On Sun, 06 Jun 2004 23:59:06 -0700, Amol Natekar wrote:

I am trying to execute a stored procedure named "sp_sysmon 1" us 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?

Most of those are generated with PRINT statements in the stored procedure.
Such messages need to be handled with a server callback. See the
ct_callback() and the CS_SRVMESSAGE_CB entries in the CTlib docs.

Michael

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.