Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: "Stern, Meir" <Meir dot Stern at gs dot com>
Subject: RE: stored procedure tutorial
Date: Sep 28 1999 10:31PM

Dear sirs,

whats wrong with this statement $insert="INSERT INTO Description VALUES

I keep on getting a error 102 syntax error near the value of $entryid[0]
what could be the problem it seems correct to me I tried it both with using
ct_sql and ct_execute

please help :)

Meir Stern
Dept: User Support Engineering
Tel: 71727

-----Original Message-----
From: Michael Peppler []
Sent: Tuesday, September 28, 1999 4:51 PM
To: SybPerl Discussion List
Subject: RE: stored procedure tutorial

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


 > Meir Stern
 > Dept: User Support Engineering
 > Tel: 71727
 > Email:
 > -----Original Message-----
 > From: Cull, Tim BGI SF []
 > 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
 > stored procedure in sybperl?  Especially from the point of view of
 > who has never had occasion to use ct_lib in C and has no idea how it
 > 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
 > values in the calls to ct_param and ct_command.
 > thanks,
 > Tim
 > -----------------------------------------------------------------------
 > Tim Cull
 > Barclays Global Investors, San Francisco
 > US Applications
 > V 415.908.7177
 > F 415.597.2352
 > Everything here is only my personal opinion, not my employer's

Michael Peppler         -||-  Data Migrations Inc.    -||-
Int. Sybase User Group  -||-
Sybase on Linux mailing list: