Re: Help for insert query using DBD oracle

[John Scoles]

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