Can't do it... the Sybase driver does not allow placeholders in a prepare
of a stored proc.  I spent the better part of a day trying to figure out
why my code wasn't working when doing something similar until I read
Cheetah's section on DBD::Sybase.

--Curt

On Mon, 9 Apr 2001, Bruce Hodge wrote:

> I am using DBD::ODBC drivers to connect to a Sybase 11.5 database. I have 
> migrated a bunch of procedures from Oracle 8i that use output parameters to 
> return data. I was migrating an abstract database interface that I built 
> dbObject.pm, which previously called the Oracle stored procedures. I 
> verified that the ODBC prepare statement was being correctly built {call 
> get_seq(?,?,?)} and when I called DBI::bind_param_inout on the 3rd output 
> parameter I got the error message "Can't bind output values (currently)". 
> Now I know I am not the only one who has ever tried this so can someone 
> please tell me how to bind Perl variables to stored procedure's output 
> parameters using DBD::ODBC.
> 
> Thanks,
> Bruce
> 
> 
>                         ```
>                        (o o)
> ------------------oOO--(_)--OOo--------------------
> Bruce Hodge            DynaScript Internet Language
> P.O. Box 428           http://www.dynascript.com
> Greenfield, NY 12833   [EMAIL PROTECTED]
> -----------------o00---------00o-------------------
> 
> 

Reply via email to