Re: DBD::ODBC column_info
"Martin J. Evans" <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.dbi.general |
|---|---|
| Organization | Easysoft Limited |
| Message-ID | <[email protected]> |
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