I've finally tracked this problem down and I believe it is down to the
code which turns off server_side_prepare if the SQL looks like a
create statement. Of course my statement looks like a create statement
because:
o it is select created_date_time_utc from test
o the code looks for CREATE or
Capacio, Paula J wrote:
Hello, I'm hoping someone can explain why one of these connect
statements work and the other doesn't. The script sets environment
values as such: $ENV{ORACLE_HOME} = /usr/oracle/product/8.1.7_64;
$ENV{ORACLE_SID} = $db_alias;#$db_alias passed to script via
$ARGV[1]
my
Capacio, Paula J [mailto:[EMAIL PROTECTED] wrote:
The code now looks like:
my $dbh;
if ($method =~ /2/) { #this works
$dbh = DBI-connect('', scott/tiger, '', 'Oracle')
or die Connect failed: $DBI::errstr\n;
}else{ #this doesn't
printIt(Just prior to connect...);
Capacio, Paula J [mailto:[EMAIL PROTECTED] wrote:
The code now looks like:
my $dbh;
if ($method =~ /2/) { #this works
$dbh = DBI-connect('', scott/tiger, '', 'Oracle')
or die Connect failed: $DBI::errstr\n;
}else{ #this doesn't
printIt(Just prior to connect...);