|Subject:||DBD ERROR: OCIStmtPrepare|
AIX 126.96.36.199 Perl: v5.8.8 built for aix-thread-multi DBI Version:1.613 DBD::Oracle: 1.24 Oracle: 10.2.0.3 DBD Oracle seems to get corrupted if I am switching back/forth between an ODBC connection and Oracle connection. for example: I have a connection to an ODBC (netezza) database and Oracle database. I can prepare and execute a statement against the ODBC connection, but when I try to prepare a subsequent statement against the Oracle database, I get the following error: ORA-24373: invalid length specified for statement (DBD ERROR: OCIStmtPrepare) [for Statement "SELECT * FROM EXTRACT_ATTR"] However, if I reverse the order of the statements (e.g. Oracle first and ODBC second), both work fine.