Then post the code to the list, and let's see if someone can spot what's
going on.
____________________________
Jeff Seger
Fairchild Semiconductor
[EMAIL PROTECTED]
____________________________
"Hawkes, Richard" <[EMAIL PROTECTED]>
05/04/2005 09:01 AM
To: Jeffrey Seger/Corporate/[EMAIL PROTECTED]
cc:
Subject: RE: ORA-03113 Error from DBI
Unfortunately yes! This is only occurring when I use the DBI module.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 04 May 2005 13:46
To: Hawkes, Richard
Cc: ''dbi-users@perl.org' '
Subject: RE: ORA-03113 Error from DBI
Are you running with the same user in both your perl script and in
sql*plus? Have you run the query successfully in sql*plus across the link
using the same user?
____________________________
Jeff Seger
Fairchild Semiconductor
[EMAIL PROTECTED]
____________________________
"Hawkes, Richard" <[EMAIL PROTECTED]>
05/04/2005 04:58 AM
To: Jeffrey Seger/Corporate/[EMAIL PROTECTED], "Hawkes, Richard"
<[EMAIL PROTECTED]>
cc: "''dbi-users@perl.org' '" <dbi-users@perl.org>
Subject: RE: ORA-03113 Error from DBI
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: 'dbi-users@perl.org'
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: "'dbi-users@perl.org'" <dbi-users@perl.org>
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.
==============================================================================
==============================================================================
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.
==============================================================================
