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 8:45PM


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.

Meir Stern
Dept: User Support Engineering
Tel: 71727

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