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: "Ellery, Michael BGI SF" <Michael dot Ellery at barclaysglobal dot com>
Subject: RE: stored proc that retuns no data
Date: Mar 25 1999 9:29PM

I like to use ct_sql() whenever I can.  Out of curiousity, what does it
return when you do an 'insert....' or a 'delete...' statement?

Thanks,

Michael Ellery
Barclays Global Investors
45 Fremont St., 6th Floor #102
San Francisco, CA  94105
(415) 908-7234 [PH],  (415) 597-2352 [FAX]
Email:  michael.ellery@barclaysglobal.com

> -----Original Message-----
> From:	Michael Peppler [SMTP:mpeppler@peppler.org]
> Sent:	Thursday, March 25, 1999 1:19 PM
> To:	SybPerl Discussion List
> Subject:	stored proc that retuns no data
> 
> Andrew J Davies writes:
>  > Hi All
>  > CTlib quickie.
>  > Whats the best way to call a stored proc ( with paramater)  thats
> returns
>  > no data (just the return code).
>  > the proc will be called several times each time the param will change.
>  > 
> 
> The easiest is
> 
> $ret = $dbh->ct_sql("exec  , , ...");
> 
> $status = $ret->[0]->[0];
> 
> Michael
> -- 
> Michael Peppler         -||-  Data Migrations Inc.
> mpeppler@peppler.org    -||-  http://www.mbay.net/~mpeppler
> Int. Sybase User Group  -||-  http://www.isug.com
> Sybase on Linux mailing list: ase-linux-list@isug.com