Brothers...any help to identify what I'm doing wrong would be greatly appreciated...
I'm putting together some Perl scripts that all connect to an Oracle database. I've put the database connectivity in a library file although I'm leaving each script's specific SQL in the script itself.
In my library file (ECClib.pm) I have
package ECClib;
my $dbh;
sub initialise(){
.
.
$dbh = db_connect($dbuser, $dbpasswd, $dbserver);
.
.
)
That's all fine and dandy, and I seem to get a good database connection. However, if I then try to use $ECClib::dbh in my parent script, it fails.
My calling script has
use ECClib;
ECClib::initialise();
my $sql="select InputID from ECCInput order by InputID";
my $sth = $ECClib::dbh->prepare($sql);
The statement handle assignment fails - debugging shows that $ECClib::dbh is undefined. What am I doing wrong?
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|