PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at bluewin dot ch>
Subject: Re: processing output from stored procedures using DBD::Sybase
Date: Aug 7 2003 4:23PM

On Wed, 2003-08-06 at 22:49, Michael Burstin wrote:
> I know I probalby posted somethign similar to this a few years ago,
> but can't seem to get into the Sybperl archives to find it.

My home machine's internet connection is *very* flaky, unfortunately.

> 
> I am trying to process the results from running sp_helpcache to see
> what tables are bound to a named cache, to see whether I need to add a
> binding for a table.


> I want to be able process the Entity Name and Type columns.  I have
> tried unsuccessfully to use both $sth->func('syb_output_params')
> and a do { }while $sth->{syb_more_results} and neither appear to
> work.  In addition, without me issuing any print statement, I get
> everything up to the "Cache Name..." and "----------..." printed to my
> screen when I call $sth->execute.  When I do a Data::Dumper of my
> results, I get $VAR1 = [ 0 ];

The problem is that the output from sp_helpcache is done via PRINT
statements, not SELECT statements. You need to write an error handler
(see the syb_err_handle attribute) and add ad-hoc processing in the
handler.

Michael