Re: DBD::Oracle, 10g Lob Refetch problem

Moin Carl,

Furst, Carl schrieb am 20.12.2010 um 15:17 (-0500):
> 
> 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 

Perl 5.8.5 is from mid-2004, so six and a half years old. Time to
upgrade to 5.8.9. (And then on to 5.10.1, and 5.12.2, if you want.
If you deal with Unicode, the newer, the better.)

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

But it says "invalid table name". What does your SQL look like?

> 1) do we need an actual Oracle server to build the DBD

No.

> if so what libs would we need to link against?

You need the Oracle client lib. The easiest should be to pick the Oracle
Instant Client, which you can find by doing a web search. The Basic or
even Basic Lite should do for your purposes. SQL*Plus is offered, too,
so I'd install that as well.

> 2) Has anyone else experienced this; building again lib32 client libs.

Experienced what exactly?

> 3) What role does oraperl have in all this? If oraperl fails to
> compile, is that a blocker for DBD?

It's all in the docs, straight at the top:

  Oraperl is an extension to Perl which allows access to Oracle
  databases.

  The original oraperl was a Perl 4 binary with Oracle OCI
  compiled into it. The Perl 5 Oraperl module described here is
  distributed with DBD::Oracle (a database driver what operates
  within DBI) and adds an extra layer over DBI method calls. The
  Oraperl module should only be used to allow existing Perl 4
  oraperl scripts to run with minimal changes; any new development
  should use DBI directly.

http://search.cpan.org/~timb/DBD-Oracle-1.16/Oraperl.pm

Hope this helps!

Best,
-- 
Michael Ludwig