Help with DBIx::SearchBuilder::Handle::Oracle...

[John Costello]

On Wed, 7 Dec 2005, Luis Campos de Carvalho wrote:
> --- David Cantrell <david at cantrell.org.uk> escreveu:
> > On Wed, Dec 07, 2005 at 05:05:32PM -0300, Luis Campos de Carvalho wrote:
> > 
> > >   My ORACLE_HOME and NLS* are correctly setted.
> > 
> > What about the SID?
> 
>   Hum... don't see your point, unless you're just being supersticious ;-) but setted anyway, no
> change on error messages (and *yes*, ORACLE_SID gets dumped with the %ENV things).

It usually doesn't hurt to club DBI with environment variables.  (That may
not be David's point, but it is my opinion.)  I typically set ORACLE_SID,
ORACLE_HOME, and TWO_TASK and shake an angry fist at the script for good
measure.  TWO_TASK is used for remote connections (which is what I'm up
to).  It appears that you are connecting to a database local to your web 
server (yes?), in which case TWO_TASK shouldn't be an necessary.

A little searching for "OCIEnvNlsCreate" and "perl" led me to several
notes ... um, heck--read this sequence of posts, including Malka
Cymbalista's last two posts and Michael Chase's follow-on note 
<http://www.codecomments.com/archive237-2005-6-508071.html>.  They 
explain the situation better.  This appears to be from dbi-users, though 
it doesn't say so.

Boiled down, the answer is: check the web server user's permissions to the
oracle libs (one possible problem) and if necessary put your environment
declarations in mod-perl's startup.pl.

I hope that helps. 

John
-----
John Costello - cos at indeterminate dot net
"You cannot propel yourself forward by patting yourself on the back."--Unknown