DBD::ODBC support bind_param_inout... The best way to see an example is to look at the tests for SQLServer and Oracle. I don't have a DB2 server to test against, at the moment, but I've tested against both SQLServer and Oracle.
Jeff > -----Original Message----- > From: Stephen More [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 12, 2005 2:30 PM > To: dbi-users@perl.org > Subject: bind_param_inout + DBD::ODBC > > 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 expected that few drivers will support this method. The > only driver currently known to do so is DBD::Oracle > (DBD::ODBC may support it in a future release). Therefore it > should not be used for database independent applications. > > Does DBD::ODBC support bind_param_inout ?? > If not, how can you call a stored procedure from perl using ODBC ? > > -Thanks > Steve More >