Mark,
Sorry about the ambiguous reply.
I did mean LD_LIBRARY_PATH earlier when I said PATH.
It is set exactly this way.
Thanks.
Raj
-----Original Message-----
From: Mark Vandenbroeck [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 19, 2001 12:19 PM
To: Patel, Raju
Cc: [EMAIL PROTECTED]
Subject: Re: (Fwd) DBI/DBD for Oracle help
Raj,
No, I don't mean PATH, I mean LD_LIBRARY_PATH. This is the environment
variable that holds a list of directories to be searched for dynamic
libraries.
Try the following before starting your perl program :
$ . oraenv
ORACLE_SID = [V816] ? <fill in your ORACLE_SID>
$ LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
$ export LD_LIBRARY_PATH
$ perl -w <your_perl_script>
Please check your Oracle and DBD::Oracle documentation for more information.
Brgds,
Mark
"Patel, Raju" wrote:
The PATH is set while running the perl script when I encounter the error.
I will check with the UNIX admin whether he set the PATH while creating make
install.
Thanks for you help.
Raj Patel
-----Original Message-----
From: Mark Vandenbroeck [ mailto:[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> ]
Sent: Monday, February 19, 2001 9:42 AM
To: Patel, Raju
Cc: Tim Bunce; [EMAIL PROTECTED]
Subject: Re: (Fwd) DBI/DBD for Oracle help
Did you have $ORACLE_HOME/lib in your LD_LIBRARY_PATH ?
Mark
Tim Bunce wrote:
----- Forwarded message from "Patel, Raju" <[EMAIL PROTECTED]>
-----
From: "Patel, Raju" <[EMAIL PROTECTED]>
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Cc: "Harris, Jamey" <[EMAIL PROTECTED]>,
"Patel, Raju" <[EMAIL PROTECTED]>
Subject: DBI/DBD for Oracle help
Date: Fri, 16 Feb 2001 14:20:42 -0600
Tim,
While using DBI/DBD for Oracle, we are having the following error:
ld.so.1: /usr/local/bin/perl: fatal: relocation error: file
/usr/local/lib/perl5/site_perl/5.005/sun4-olaris/auto/DBD/Oracle/Oracle.so:
symbol OCIInitialize: referenced symbol not found
Killed
The environment we are running as follows:
Perl 5.005_03
DBD Oracle 1.06
DBI 1.14
Oracle 8i Enterprise edition Release 8.1.6.2.0
After searching the web, we found that some one has a similar problem.
The message suggest the following fix:
Change the following line in Makefile.PL from
$::opt_p = ''; # alter preference for oracle.mk over proc
to
$::opt_p = 1; # alter preference for oracle.mk over proc
We have tried this fix but it did not work.
Please help us resolve the issue.
Your help is greatly appreciated.
Raj Patel
----- End forwarded message -----
--
Mark Vandenbroeck Mobile : +32-495-59.55.62
EMEA Support Information Systems Email : [EMAIL PROTECTED]
AIM : markvdb
--
Mark Vandenbroeck Mobile : +32-495-59.55.62
EMEA Support Information Systems Email : [EMAIL PROTECTED]
AIM : markvdb
