On 20/12/10 20:17, 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 

Did you run make test when you installed DBD::Oracle with valid login and if so 
what was the output?
 
> 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)

An example of the code and the schema for the table would be useful here.
 
> 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

I use

NLS_LANG=AMERICAN_AMERICA.AL32UTF8

> 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?

Michael answered these.

I use the latest Oracle Instant Client and have no problems updating lobs.

Example code with error output and schema for the tables involved might help us 
help you.

It is relatively easy to build DBD::Oracle against Instant Client 11.2 - just 
get the basic, sdk and sqlplus zips, unzip them anywhere, set 
LD_LIBRARY_PATH=/where_you_unzipped them and export then run perl Makefile.PL, 
make. You should set your ORACLE_USERID, TWO_TASK or tnsnames up so sqlplus is 
working then run make test - does this succeed and if not what is the output?

e.g. for my database here with a SID of "devel" where the database is running 
on betoracle.easysoft.local and my user is fred/password I do:

export ORACLE_USERID=fred/password
export TWO_TASK=//betoracle.easysoft/local/devel

I can run sqlplus with:

sqlplus -S fred/passw...@$betoracle.easysoft.local:1521/devel

to connect and those exported variables allow a make test to run.

Martin
-- 
Martin J. Evans
Easysoft Limited
http://www.easysoft.com

Reply via email to