Thank you! That worked and it returned the result set of my sql query.
Can I bother you with another question - how do I open up a file and
redirect the result set into it?
Deb Vredeveld
Okay thanks, I added "my $dbh;" prior to the subroutine and am still
receiving the same error. Here is the code:
#!/usr/local/bin/perl
#
$ENV{'ORACLE_HOME'} = '/apps/oracle/product/8.1.7';
$ENV{'NLS_LANG'}= 'AMERICAN_AMERICA.WE8ISO8859P1';
$ENV{'NLS_DATE_FORMAT'} = 'DD-MON-RR';
#$gdb
I am brand new to coding with DBI and am trying to set up a simple
prepare/execute/fetch routine. I'm receiving the following error on my
prepare statement line: "Can't call method "prepare" on an undefined
value at ./test.cgi line 51."
Here's is my sub:
sub db_statement
{
my $sth = $dbh-
What is the latest DBI version that you have running? I'm trying to use
1.14 in a Perl program against an Oracle 9.0.1.3 database on SunOS 5.7 and
am not able to connect.
Error message is: DBI->connect(DUMY) failed: ERROR OCIEnvInit
However, when running the "perl Makefile.PL -p" and "ma