HELP: Need a little help on using PerlV5.003 with a Sybase stored procedure
Quote:
> >Hi,
> > i'm trying to call a Sybase stored procedure which
> > makes a select and returns a value in the output
> > argument.
> > Here is what i have:
> > Stored procedure:
> > Perl script:
> > -- I'm using CTlib --
^^^
Unfortunately for Perl users, the Sybase Transact-SQL syntax for local
into the SQL command string to execute the stored procedure. Try single
Quote:
> > $dbh->ct_sql($sql_cmd);
^^^^^^
I have not looked closely at ct_sql() in CT-Lib module. But, in the
DB-Lib module, there were separate specific methods to handle stored
procedures, e.g. methods for output parameters, result sets, and return
status. You may need to re-code the above with the CT-Lib methods to
handle stored procedures.
Quote:
> > -- cur_bus_day appears to be null --
> > -- next_row loop also got me nothing --
> What I do is the following:
[SNIP]
> HighWire Press -- Stanford University
-- Bill
-----------------------------------------------------------------------
Tiburon, Inc./3333 Durham-Chapel Hill Blvd Suite E-100/Durham, NC 27707
