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 c
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 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
>>
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