John Apreacite your help. And I'm going to execute your recommendations
Luis Fernando Lopez Mariz CATE GE - Enterprise Access Engineering 52 (55) 22620675 Red Banamex 50675 -----Original Message----- From: John Scoles [mailto:sco...@pythian.com] Sent: Thursday, February 04, 2010 9:48 AM To: Lopez Mariz, Luis Fernando [BMX-BNAMEX] Cc: 'Michael Nhan'; 'dbi-users@perl.org' Subject: Re: Help for insert query using DBD oracle 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 >
