Any possiblity to run the perl scripts for both oracle 8i and 9i environments from the same server.

Any possiblity to run the perl scripts for both oracle 8i and 9i environments from the same server.

am 21.05.2007 04:20:14 von Chandru

------_=_NextPart_001_01C79B4E.90D7F5B0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

> Hi,
>=20
> Initially we had only oracle 8i setup and used DBD-Oracle-1.08 &
> DBI-1.19 as perl interface.
>=20
> Now we have upgraded some of our databases to oracle 9i and using
> DBD-Oracle-1.16 & DBI-1.45 for oracle9i.
>=20
> Now perl scripts running in oracle8i failed with the following error
> message.
>=20
> DBI Error Message:
>=20
> ERROR OCIEnvNlsCreate (check ORACLE_HOME and NLS settings etc.)
>=20
> Script Exiting...
>=20
> Is there any possibility to run the perl scripts for both 8i and 9i
> environments from the same server.
>=20
> Thanks,
> Chandru.

------_=_NextPart_001_01C79B4E.90D7F5B0--

Re: Any possiblity to run the perl scripts for both oracle 8i and 9i environments from the same serv

am 27.05.2007 07:50:16 von gallagher.paul

Hi Chandru,
I think you should be able to connect to both 8 and 9. Suspect the
error means exactly what it says ... check the environment setup
carefully. Can you post full details of the problem if you still
encounter it?
Paul

On 5/21/07, Chandrasekaran.k wrote:
> > Hi,
> >
> > Initially we had only oracle 8i setup and used DBD-Oracle-1.08 &
> > DBI-1.19 as perl interface.
> >
> > Now we have upgraded some of our databases to oracle 9i and using
> > DBD-Oracle-1.16 & DBI-1.45 for oracle9i.
> >
> > Now perl scripts running in oracle8i failed with the following error
> > message.
> >
> > DBI Error Message:
> >
> > ERROR OCIEnvNlsCreate (check ORACLE_HOME and NLS settings etc.)
> >
> > Script Exiting...
> >
> > Is there any possibility to run the perl scripts for both 8i and 9i
> > environments from the same server.
> >
> > Thanks,
> > Chandru.
>