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: Thomas Santamaria <tsant at ms dot com>
Subject: Re: Prints for stored procs not working in Perl5
Date: Aug 23 1999 10:24PM

Have you installed a message handler?

Ravipudi, Murali wrote:

> I guess you can only get the content of the result sets your procedure
> returns, not the 'print'ed messages.
> Probably you can use 'select' to get the messages in their own result sets,
> so, you have them coming out too, when you run your proc.
>
> -murali
>
> > -----Original Message-----
> > From: kvk@hmco.com [SMTP:kvk@hmco.com]
> > Sent: Monday, August 23, 1999 5:01 PM
> > To:   SybPerl Discussion List
> > Subject:      Prints for stored procs not working in Perl5
> >
> >
> > I have always used prints in stored procs to get output.  I'm doing
> > it now with Perl5 but the messages aren't coming out.
> >
> > Here's any example--
> >
> >
> > -----------------------------------------------------------
> >  create fooproc as print "This is a test"
> > --------------------------------------------------
> > #!/usr/local/bin/perl5
> > use Sybase::DBlib;
> >
> > $DB = Sybase::DBlib->dblogin('foouser', 'footest', 'CORPTSTW',
> > 'printproc');
> >
> > $sql="exec fooproc";
> >
> > $DB->sql($sql);
> >
> > --------------------------------------------------
> >
> > I get nothing on stdout when I run the program.
> > Any clue?