trance12
asked on
perl script querying a oracle 10g DATABASE
Hi
We've recently upgraded to oracle 10G Release 2.
When browsing a web page that executes a perl script in the backend, it fails with a oracle error ora-03113 end of file on communication channel error.....it throws that error to the apache logs and crashes....the server is running perl 5.8.5 with DBD-Oracle 1.16.....it was running fine when we had oracle 9i running...
execute error: ORA-03113: end-of-file on communication channel (DBD ERROR:
OCIStmtExecute) (DBD ERROR:
OCITransRollback)'
<- DESTROY= undef during global destruction
can someone advice?
We've recently upgraded to oracle 10G Release 2.
When browsing a web page that executes a perl script in the backend, it fails with a oracle error ora-03113 end of file on communication channel error.....it throws that error to the apache logs and crashes....the server is running perl 5.8.5 with DBD-Oracle 1.16.....it was running fine when we had oracle 9i running...
execute error: ORA-03113: end-of-file on communication channel (DBD ERROR:
OCIStmtExecute) (DBD ERROR:
OCITransRollback)'
<- DESTROY= undef during global destruction
can someone advice?
can ypu please post the corresponding perl command
The DBD::Oracle module has a newer version: 1.22. You could try upgrading to the latest version.
ASKER
This is the exact error
[Mon Nov 17 16:25:21 2008] null: DBD::Oracle::db DESTROY failed: ORA-03113: end-of-file on communication channel (DBD ERROR: OCITransRollback) during global destruction.
The error happens at random...however once we restart apache, the error does not appear for a few hours and then all of a sudeen it starts again...
i've checked memory stats etc on the server and it looks fine..
[Mon Nov 17 16:25:21 2008] null: DBD::Oracle::db DESTROY failed: ORA-03113: end-of-file on communication channel (DBD ERROR: OCITransRollback) during global destruction.
The error happens at random...however once we restart apache, the error does not appear for a few hours and then all of a sudeen it starts again...
i've checked memory stats etc on the server and it looks fine..
ASKER
That error is what writes to the apache logs...
On the web page though, it throws this error
Can't call method "execute" on an undefined value at /usr/local/apache/htdocs/r esell/inde x.cgi line 26.
which is this query
my $sql = "SELECT product_id, header_link,footer_link, middle_page_link FROM reseller WHERE reseller_id = '$resell'";
my $sth = $WAP::lda->prepare($sql);
$sth->execute();
On the web page though, it throws this error
Can't call method "execute" on an undefined value at /usr/local/apache/htdocs/r
which is this query
my $sql = "SELECT product_id, header_link,footer_link, middle_page_link FROM reseller WHERE reseller_id = '$resell'";
my $sth = $WAP::lda->prepare($sql);
$sth->execute();
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER