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
