|
|
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
|
