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.
==============================================================================