On 20/12/2010 3:17 PM, Furst, Carl wrote:
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)
To start we will need to see the output from the perl Makefile.PL and
the make, and make test to see if there is something wrong with the way
it is being built
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.
Next we will need to see an example of your code as there are at least 4
different ways to write lob fields with DBD::Oracle
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?
No you do not need a server you only need the client. Instant client
should work fine
2) Has anyone else experienced this; building again lib32 client libs.
Solaris SPARC tends to have more problems that other OS when attempting to
compile DBD::Oracle in 32bit but since you
have it working you should be past this point
3) What role does oraperl have in all this? If oraperl fails to compile, is
that a blocker for DBD?
No it is a separate and deprecated hunk of code for perl 4. It may be a
symptom of a deeper problem so we need to see the Makefile.pl and make
output to know for sure.
Cheers
John Scoles
Thanks in advance,
Carl Furst
CMS Developer
MLB Advanced Media
**********************************************************
MLB.com: Where Baseball is Always On
