RE: Help for insert query using DBD oracle

2010-02-05 Thread Lopez Mariz, Luis Fernando
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(46

Re: Help for insert query using DBD oracle

2010-02-04 Thread John Scoles
ex 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

RE: Help for insert query using DBD oracle

2010-02-04 Thread Lopez Mariz, Luis Fernando
] 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 occu

RE: Help for insert query using DBD oracle

2010-02-04 Thread Lopez Mariz, Luis Fernando
2010, Lopez Mariz, Luis Fernando wrote: > Date: Wed, 3 Feb 2010 09:53:55 -0600 > From: "Lopez Mariz, Luis Fernando " > > To: "'dbi-users@perl.org'" > Subject: RE: Help for insert query using DBD oracle > > Guys > > Sorry to disturb you but I

Re: Help for insert query using DBD oracle

2010-02-04 Thread John Scoles
Like the other says a ORA-03113 error. is usually an indication that something else is awry. To really set this down we will need to know what version of DBI and DBD::Oracle you are using as well if you can send me a dbd_verbose run of you code we can narrow down the problems a little c

RE: Help for insert query using DBD oracle

2010-02-03 Thread Michael Nhan
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 si

RE: Help for insert query using DBD oracle

2010-02-03 Thread Michael Nhan
Luis Fernando wrote: Date: Wed, 3 Feb 2010 09:53:55 -0600 From: "Lopez Mariz, Luis Fernando " To: "'dbi-users@perl.org'" Subject: RE: Help for insert query using DBD oracle Guys Sorry to disturb you but I really need your advice, any suggestion is apprec

RE: Help for insert query using DBD oracle

2010-02-03 Thread Lopez Mariz, Luis Fernando
Guys Sorry to disturb you but I really need your advice, any suggestion is appreciated. Let me explain quickly, one application built in perl was working fine with DBD oracle for many years . One month ago, DB team want to test in lab with RAC cluster technology of Oracle ,so DB team did mi