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: stored procedure tutorial
Date: Sep 28 1999 8:51PM

Stern, Meir writes:
 > Hi,
 > 
 > This might be out of context for this discussion group however I would
 > really appreciate it if someone takes the time to answer this question.
 > I am trying to pass a parameter to  stored proc from my script to a text
 > datatype (I need the datatype to be over 255 char so that I can pass a
 > description over to the database)it seems that I cannot do that. Could
 > anybody give me a suggestion on how to get around this problem. I need to
 > have a description field which should be able to be queried and modified as
 > well. I Would like to thank you in advance for your kind help.

Unfortunately you can't do that. TEXT/IMAGE datatypes can't be passed
as parameters to stored procs.

If this column needs to be updated from the client you will have to do 
it directly using ct_execute() or ct_get_data/ct_send_data, or with
dbwritetext() if you use DBlibrary.

Michael

 > 
 > Meir Stern
 > Dept: User Support Engineering
 > Tel: 71727
 > Email: meir.stern@ny.email.gs.com
 > 
 > 
 > 
 > -----Original Message-----
 > From: Cull, Tim BGI SF [mailto:Tim.Cull@barclaysglobal.com]
 > Sent: Tuesday, September 28, 1999 12:11 PM
 > To: SybPerl Discussion List
 > Subject: stored procedure tutorial
 > 
 > 
 > Can anyone point me to a really comprehensive tutorial about how to call a
 > stored procedure in sybperl?  Especially from the point of view of someone
 > who has never had occasion to use ct_lib in C and has no idea how it works?
 > I'd especially appreciate a start-to-finish example of calling a stored
 > procedure with more than one input parameter and at least one output
 > parameter and an explanation/listing of the meanings of the various constant
 > values in the calls to ct_param and ct_command.
 > 
 > thanks,
 > 
 > Tim
 > 
 > 
 > -----------------------------------------------------------------------
 > 
 > Tim Cull
 > Barclays Global Investors, San Francisco
 > US Applications
 > tim.cull@barclaysglobal.com
 > V 415.908.7177
 > F 415.597.2352
 > 
 > Everything here is only my personal opinion, not my employer's
 > 

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