Well had a look at you log you sent me and here is the important bit
OCIStmtExecute(4600e4,4d1b28,46030c,1,0,0,0,32)=ERROR
OCIErrorGet(46030c,1,"<NULL>",ffbecdc4,"Error while trying to retrieve
text for error ORA-03113",1024,2)=SUCCESS
OCIErrorGet after OCIStmtExecute (er1:ok): -1, 3113: Error while trying
to retrieve text for error ORA-03113
OCIErrorGet(46030c,2,"<NULL>",ffbecdc4,"Error while trying to retrieve
text for error ORA-03113",1024,2)=NO_DATA
ERROR EVENT 3113 'Error while trying to retrieve text for error
ORA-03113 (DBD ERROR: OCIStmtExecute)' on DBI::st=HASH(0x422ba0)
!! ERROR: 3113 'Error while trying to retrieve text for error
ORA-03113 (DBD
I will now translate from OCI speak into English
1) I received something other than status='OCI_SUCCESS' back from the
server on the execute (could be an error I do not know)
2) I will now get the error message and status
3) the Status is NO_DATA and the error code is ORA-03113
4) I an throwing yet another error as I cannot find any data for ORA-03113
In other words I cannot find out what the error is as I cannot talk to
anyone anymore after this??
Like the others says this is most likely some sort of configuration
here is what one docs says
there was a communication error that requires further investigation.
First, check for network problems and review the SQL*Net setup. Also,
look in the alert.log file for any errors. Finally, test to see whether
the server process is dead and whether a trace file was generated at
failure time.
cheers
John Scoles
Lopez Mariz, Luis Fernando wrote:
Apreciate your help thans a lot
Luis Fernando Lopez Mariz
CATE GE - Enterprise Access Engineering
52 (55) 22620675
Red Banamex 50675
-----Original Message-----
From: Michael Nhan [mailto:mn...@watson.wustl.edu]
Sent: Wednesday, February 03, 2010 9:12 PM
To: Lopez Mariz, Luis Fernando [BMX-BNAMEX]
Cc: 'dbi-users@perl.org'
Subject: RE: Help for insert query using DBD oracle
Hi,
The ORA-03113 is most likely not cause by dbi/dbd-oracle directly. But what is
causing the ORA-03113 needs to be tracked down and that will need you to do
some tests. First lets see if this error occurs for all clob columns in the
oracle-11 rac database. Create a simple table with a single clob columns and
insert the same clob values that is failing into it via perl. If the insert
works, then we need to take a look at what is wrong with the table that is
failing. If it fails then we need to proceed to the next test, which is to see
if it works with the client's sqlplus, the sqlplus that is part of the 9i
client you are using with perl. If the client's sqlplus fails, then we need to
see if its client version specific by installing a oracle 11 client and seeing
if that sqlplus works. If it doens't then you need to file a bug with oracle
and see about getting a patch as you have a repeatable test case. If it works
with a new client sqlplus then you need to see if compiling a new dbd with the
new client will also work. If it isn't a database bug its probably a
compatibility between the 9i client and the oracle 11 rac database.
Regards,
Michael
