Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
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