Help with DBIx::SearchBuilder::Handle::Oracle...
cos at indeterminate.net
Wed Dec 7 22:15:12 GMT 2005
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
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 Costello - cos at indeterminate dot net
"You cannot propel yourself forward by patting yourself on the back."--Unknown
More information about the london.pm