does it reproduce in sql*plus? ORA-3113 quite often means call Oracle support. >From asktom.oracle.com: The underlying cause of a 3113 can be diagnosed typically by:
o inspecting the alert log on the server. There should be a message in there typically that tells of the error occuring and gives the name of a trace file. o the trace file will contain more details. Most importantly, you can see the SQL statement that was executing usually at the time of the crash. This can be useful in diagnosing the statement that is giving us a hard time. The remainder of the trace file will not be very useful to you -- but it will be useful to support which is your next step.... o contact support with the contents of the trace file. For errors like this, the information in the trace file can be used by support/development to track down the cause of this error. "Hawkes, Richard" <[EMAIL PROTECTED]> wrote: 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" 05/03/2005 10:36 AM To: "'[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. ============================================================================== __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
