On Fri, 30 Aug 2002 15:24:59 -0700 (PDT) Saman Ranatunga <[EMAIL PROTECTED]> wrote:
> Hi, I think DBI is messed up. I recently switched to Oracle9i > from 8i and the same exact perl code stopped working!!! Have you re-built DBD::Oracle after changing your version of Oracle? OCI applications, including DBD::Oracle, are linked to shared libraries in the Oracle home tree and there is no guarantee that the thunks in an Oracle 8i library match those in a Oracle 9i library. Message text entries almost never line up either. > Please note that normal bind variables do work, like > 'select * from crap where crap_id = ? ' > > Also, the same exact code works on the previous database.. If you leave the SQL*Net and OCI libraries in an Oracle 8i home, you can continue to use the old DBD::Oracle. Just use the old tree for ORACLE_HOME. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
