bind_param_inout + DBD::ODBC

2005-10-12 Thread Stephen More
I am currently having a problem calling a stored procedure on an iSeries. DBD::ODBC::st execute failed: [unixODBC][IBM][iSeries Access ODBC Driver]Error in assignment. (SQL-22018)(DBD: st_execute/SQLExecute err=-1) In looking through the perldoc doc for DBI I found: bind_param_inout It is

Re: Dbi, Oracle, CursorName

2005-10-12 Thread Jonathan Leffler
On 10/11/05, Charles Jardine [EMAIL PROTECTED] wrote: Nardin, Simon wrote, on 11/10/2005 09:05: I'm using perl to access Oracle database. Everything is going well, but now I have a question about using CursorName. I was searching on the net for examples without success how to use cursors

Re: bind_param_inout + DBD::ODBC

2005-10-12 Thread Dan Scott
DBD::DB2 (http://search.cpan.org/dist/DBD-DB2/DB2.pod) supports bind_param_inout, but it would require you to use the DB2 Connect Personal Edition or DB2 Connect Unlimited for iSeries to access iSeries from your Linux, UNIX, or Windows box. Dan On 10/12/05, Stephen More [EMAIL PROTECTED] wrote:

DBD::Oracle and $sth-{PRECISION}

2005-10-12 Thread Eric Lenio
Hi, In perl 5.8.3, DBD::Oracle 1.14, DBI 1.47 I get expected values when I look at $sth-{PRECISION} to retrieve the lengths of varchar2 columns for a given table. I'm now testing perl 5.8.7, DBD::Oracle 1.16, and DBI 1.48 and with the same table the values in $sth-{PRECISION} for varchar2's are