Hi All, I've got a script that makes a call to an oracle database. It just attempts to open a handle...thats it:

----
#!/usr/perl5/5.8.4/bin/perl -w

use DBI;

$host = "bo.boo.com";
$sid = "AAAA";
$user = 'secret';
$passwd = 'evenmoresecret';


$dbh = DBI->connect("dbi:Oracle:host=$host;sid=$sid", $user, $passwd);

$dbh->disconnect;
---
[download]

Now if I run the script in shell where I have LD_LIBRARY_PATH environment variable defined it works just peachy. However if I don't first define LD_LIBRARY_PATH in the shell I get the following error:

---
install_driver(Oracle) failed: Can't load '/usr/perl5/site_perl/5.8.4/
+sun4-solaris-64int/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle:
+ ld.so.1: perl: fatal: libclntsh.so.10.1: open failed: No such file o
+r directory at /usr/perl5/5.8.4/lib/sun4-solaris-64int/DynaLoader.pm 
+line 230.
 at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expecte
+d
 at ./test2.pl line 12
--
[download]

I've tried inserting:

--
BEGIN {
$ENV{'LD_LIBRARY_PATH'}='/local/src/local.perl/oracle/instantclient_10
+_2';
}
--
[download]

at the beginning of by script but the result is the same error as I see if I have an undefined LD_LIBRARY_PATH. Any suggestions as to what I'm missing here?

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.