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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.