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 peppler dot org>
Subject: Re: RPC
Date: Nov 1 2000 11:05PM

AGaneshalingam@globewireless.com writes:
 > How do I send 4 parameters to a SP. I have success in sending 1 param. This
 > is my code for 1 param:
 > 
 > 	%param = (name => '@message', datatype => CS_CHAR_TYPE, status =>
 > CS_INPUTVALUE, value => "My cat likes to watch Tom and Jerry", indicator =>
 > CS_UNUSED);
 > 
 > $dbh->ct_command( CS_RPC_CMD, $sql_stmt, CS_NULLTERM, CS_UNUSED);
 > $dbh->ct_param(\%param);
 > $dbh->ct_send();

Just repeat the ct_param() call the required number of times, setting
the values in %param correctly, of course.

After you have called ct_param for each parameter, call ct_send.

Michael
-- 
Michael Peppler - Data Migrations Inc. - mpeppler@peppler.org
http://www.mbay.net/~mpeppler - mpeppler@mbay.net - AIM MPpplr
International Sybase User Group - http://www.isug.com
Sybase on Linux mailing list: ase-linux-list@isug.com