Hi Jeffrey, thanks for your help. I have added those parameters, but unfortunately it doesn't seem to make a lot of difference. The errors are now just appearing earlier:
DBD::Oracle::st execute failed: ORA-03113: end-of-file on communication channel (DBD ERROR: OCIStmtExecute) at ./query_db2.cgi line 30. DBD::Oracle::st execute failed: ORA-03113: end-of-file on communication channel (DBD ERROR: OCIStmtExecute) at ./query_db2.cgi line 30. The SQL Statement I am running is: select max(request_id) from [EMAIL PROTECTED] I can select rows from tables in the current DB with no problem. It's just the link that seems to be letting me down. Help! Richard -----Original Message----- From: [EMAIL PROTECTED] To: Hawkes, Richard Cc: '[email protected]' Sent: 03/05/2005 16:07 Subject: Re: ORA-03113 Error from DBI That's a client side error meaning that you have been disconnected without trapping the server side error. Try setting RaiseError => 1 in your dbhandle and see if that gets the server side error. $dbh = DBI->connect($dsn, $user, $password, { RaiseError => 1, AutoCommit => 0 }); Depending on how your code is structured, and what the real error is, that may trap the error before you get disconnected. Also look for differences between what you are doing in your script and what you are doing when you run the query in sql*plus such as different user, different client version, etc.... (You can run the query successfully in sql*plus, right?) ____________________________ Jeff Seger Fairchild Semiconductor [EMAIL PROTECTED] ____________________________ "Hawkes, Richard" <[EMAIL PROTECTED]> 05/03/2005 10:36 AM To: "'[email protected]'" <[email protected]> cc: Subject: ORA-03113 Error from DBI Hi guys, I am trying to resolve a horrible error I am getting, and I really don't know where to start! I have created a Database link in Oracle and created a view to one of the tables in it. Now when I run the SQL statement, I get: ORA-03113: end-of-file on communication channel (DBD ERROR: OCIStmtExecute) I really have no idea where to begin on this one. Hope you can help Richard ======================================================================== ====== This message is for the sole use of the intended recipient. If you received this message in error please delete it and notify us. If this message was misdirected, CSFB does not waive any confidentiality or privilege. CSFB retains and monitors electronic communications sent through its network. Instructions transmitted over this system are not binding on CSFB until they are confirmed by us. Message transmission is not guaranteed to be secure. ======================================================================== ====== ============================================================================== This message is for the sole use of the intended recipient. If you received this message in error please delete it and notify us. If this message was misdirected, CSFB does not waive any confidentiality or privilege. CSFB retains and monitors electronic communications sent through its network. Instructions transmitted over this system are not binding on CSFB until they are confirmed by us. Message transmission is not guaranteed to be secure. ==============================================================================
