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

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.

Relevant Pages

  • Re: perl extension for PHP - stuck?
    ... primarily because I have perl working with oracle and not php and ... So I want to use my old perl scripts, ... functionality of php. ... We have Perl scripts and we call them from PHP just using fopenand have Perl send back simple text delimited results, or using CuRL instead, then just parse the returned text in PHP. ...
    (comp.lang.php)
  • Cant locate DBI.pm
    ... We have some perl scripts to run. ... getting "Can't locate DBI.pm" error to execute the file. ... oracle 9 from this perl script. ...
    (perl.dbi.users)
  • Re: ANNOUNCE: DBD:Oracle 1.18
    ... Well a warning in one compiler is better than and error in an other so I ... This might be a problem more with the older oracle OCI in your client. ... perl -Mblib t/26exe_array.t ...
    (perl.dbi.users)
  • Re: DBD Oracle 1.20 ORA-24334 Error
    ... On the premise instant client and also tried to run perl Makefile.PL -V ... the status after having connected to Oracle ... Failed 2/33 tests, 93.94% okay ...
    (perl.dbi.users)
  • Re: float bug? perl 5.8, DBI and oracle 10.2.0
    ... If you want to store high precision numbers in oracle, you've got 38 decimal digits to play with, and with minimal coaxing perl will handle them as strings at the appropriate points so that the exact values go in and come out. ... I haven't done any numerical work in 10 years or so, but I seem to recall that one can reasonably expect 6 or so decimal significant digits from a 32 bit floating point number - I'll go out on a limb and hazard that one can expect 12 or so digits from a 64 bit floating point number - at any rate I'd be very surprised to get 18 significant digits. ...
    (perl.dbi.users)