DBD::Oracle, 10g Lob Refetch problem
[email protected] ("Furst, Carl")
| Newsgroups | perl.dbi.users |
|---|---|
| Message-ID | <1D807399669FAF4B8FFD0C3B7F9C1ECA0F86FB6B@MLBAM-EXCH01.MLBAM.mlb.org> |
Hello, I just built DBD::Oracle 1.26 on Solaris SPARC 2.10 using perl 5.8.5 32 bit against client 10.0.2.4 We've been having trouble since day one. The biggest problem is that we are having a problem writing LOB fields. We get the following error: DBD::Oracle::st execute failed: ORA-00903: invalid table name (DBD ERROR: OCIStmtExecute/LOB refetch) We think it's the LOB refetch that's causing the issue. the encoding of the database and the NLS_LANG parameter are both UTF8 nls_lang specifically is AMERICAN_AMERICA.UTF8 If anyone has any advice about this, it would be a big help. My questions are the following: 1) do we need an actual Oracle server to build the DBD - if so what libs would we need to link against? 2) Has anyone else experienced this; building again lib32 client libs. 3) What role does oraperl have in all this? If oraperl fails to compile, is that a blocker for DBD? Thanks in advance, Carl Furst CMS Developer MLB Advanced Media ********************************************************** MLB.com: Where Baseball is Always On
smime.p7s
(application/x-pkcs7-signature, 2.2 KB) - not displayed