[Private message returned back to list]
Please send further questions to the mailing list instead of by private
email. Other list members may want to contribute.
>
>
>The query does work in Sql*plus. I'm not getting any errors from my
>connect string. Here is the sub with my dbh definition:
>
>sub db_connect
>{
>use DBI;
>use strict;
>
>my $db_connect = 'DUMY';
>my $dbh = DBI->connect("dbi:Oracle:$db_connect","FMC","FMC")
> or die "Database connection not made: $DBI::errstr";
>}
Your $dbh is local to your db_connect subroutine. It's value is not defined
outside of 'db_connect'. If you
use strict;
these kind of errors will be catched.
Either put
my $dbh;
outside of any subroutine, or start passing it around as parameter/return
value.
--
felix
_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
