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:
> 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.
> Meir Stern
> Dept: User Support Engineering
> Tel: 71727
> Email: firstname.lastname@example.org
> -----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.
> 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.
email@example.com -||- http://www.mbay.net/~mpeppler
Int. Sybase User Group -||- http://www.isug.com
Sybase on Linux mailing list: firstname.lastname@example.org