Perl5.8 Oracle DBI connects failing
------=_Part_33249_7961932.1163733683353
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Hi,
I am unable to connect to my oracle database I am getting the following
errors..
" DBI connect Failed: connect Failing because of ERROR OCIEnvNlsCreate.
Check ORACLE_HOME env var, NLS settings, permissions, etc."
I stumble into this when I try to execute
"$dbh->selectall_arrayref( $sql )"
I am running Perl5.8 on Red Hat Enterprise Edition 3 and using DBD Oracle
1.17, DBI 1.46 trying to access Oracle 10g
I am not sure which module was compiled against which one..?
any insight into whats happenign here can be great.
Thanks
--
-vmbharathi
I can resist anything but temptation
------=_Part_33249_7961932.1163733683353--
Re: Perl5.8 Oracle DBI connects failing
Looks like DBD::Oracle is not finding the correct OCI files. Have you
updated you Oracle DB or client lately. If so you will have to recompile
DBD::Oracle to run with it.
""Bharathi Masilamani"" <vmbharathi [at] gmail.com> wrote in message
news:6a9117130611161921x715151b9hd18d8fbac8ecefd2 [at] mail.gmail .com...
> Hi,
> I am unable to connect to my oracle database I am getting the following
> errors..
>
>
> " DBI connect Failed: connect Failing because of ERROR OCIEnvNlsCreate.
> Check ORACLE_HOME env var, NLS settings, permissions, etc."
>
> I stumble into this when I try to execute
>
> "$dbh->selectall_arrayref( $sql )"
>
> I am running Perl5.8 on Red Hat Enterprise Edition 3 and using DBD Oracle
> 1.17, DBI 1.46 trying to access Oracle 10g
>
> I am not sure which module was compiled against which one..?
>
> any insight into whats happenign here can be great.
>
>
> Thanks
> --
>
> -vmbharathi
>
> I can resist anything but temptation
>