On 08/08/12 16:24, Manikantan, Madhunapanthula_Naaga wrote:
Hello Evans, I am using Class::DBI::Sybase::set_up_table method. It fails with the below error. DBD::ODBC::st execute failed: [unixODBC][Driver Manager]Function sequence error (SQL-HY010) at /u/manikanm/column_info_test.pl I debugged and realized the error comes when we try to call ‘execute’ on the ‘statement handle’ returned by ‘column_info’ method. Please find below is the code to reproduce the issue. Please note that it doesn’t fail if we use ‘fetchall_arrayref’ on the ‘statement handle’ returned by ‘column_info’. Please let me know if you need more information to reproduce the issue. Can you please fix this? Help much appreciated !!! Thanks, Manikantan.
I think you've answered your own question. column_info returns a result-set (as if you issued prepare then execute) and you cannot call execute on the stmt handle returned from column_info. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com