Susan,
My guess is that you installed DBD::Oracle with your environment pointing to
8.1.7.
When you install DBD::Oracle, it is linked with the Oracle client
libraries. If you run a program linked in an 8.1.7 environment, but (because
of your environment variables) it picks up the dynamic libraries of an older
version, you're asking for trouble. You should provide your DBD::Oracle with
the client libraries it was linked with at install time.
So, if you have a mixed version environment, the best way to go is :
* Install DBD::Oracle against the highest version
* Always keep your environment variables (ORACLE_HOME, PATH and
LD_LIBRARY_PATH) pointing to this same environment.
If you need to connect to other versions, use SQL*Net.
Hope this helps,
Brgds,
Mark
[EMAIL PROTECTED] wrote:
> I have a program that sets the Oracle environment for 8.1.7 and connects to
> the database just fine. If I resent the environment to 8.0.5 and try to
> connect to an 8.0.5 database, it fails with a OCIEnvInit error. If I leave
> the environment at 8.1.7 and connect to the 8.0.5 database, it succeeds.
> If I run from cron with no environment set, it works fine.
>
> I am obviously missing something basic about the Oracle environment the dbd
> needs to run. Should an environment never be set or should it always be
> set to 8i?
>
> Thanks
>
> Susan
>
> *************************************************************************
>
> PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is
> for the exclusive use of addressee and may contain proprietary,
> confidential and/or privileged information. If you are not the intended
> recipient, any use, copying, disclosure, dissemination or distribution is
> strictly prohibited. If you are not the intended recipient, please notify
> the sender immediately by return e-mail, delete this communication and
> destroy all copies.
>
> *************************************************************************
--
Mark Vandenbroeck Mobile : +32-495-59.55.62
Business Process Manager Email : [EMAIL PROTECTED]
EMEA Support Information Systems AIM : markvdb
