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
cheers
John Scoles
Lopez Mariz, Luis Fernando wrote:
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 migrate all my tables, permissons, etc to RAC
enviroment , so I did change the connection propierties to point to RAC enviroment,
it give me a huge problem related with CLOB data type , already try to set oratypes
=> ORACLOB or oratypes => 8 without success. I did discover , if I try insert
less of 200 characters in to CLOB column , the insert query is success , if the size
is more than 200 characters I get ORA-03113 error.
To give more detail how I make the connection:
sub Insert_RAC {
$sql_stmt= "INSERT INTO smtools.sm_stg_tb
(REQUEST_ID,APP_STATUS,WEB_URL,APP_SERVERS,LDAP_GROUP,WEB_PORT,SSL_SECURITY,PROTECTED_URI,UNPROTECTED_URI,AGENT_NAME,AGENT_COOKIES,AGENT_HDRS,AGENT_TIMEOUT,STG_SERVERS,ASSIGNED_TO,SUBMITTED_DATE,LAST_UPDATED,LAST_UPDATED_BY,COMP_DATE,COMPLETED_DATE,PRIV_COMMENTS,COMMENTS,NOUSER,FAILEDLOGIN,UNAUTH,AGENT_CONFIG_OBJECT)
VALUES
(200700180011138,'COMPLETED','https://traderecords.europe.citigroup.net','trimsastxp14','internal','443',NULL,'%2F','%2FHelloTrims','153622-titaneur-trimsasmdp14-443,153622-titaneur-trimsasmdp15-443)',NULL,NULL,NULL,NULL,'DUMMY
USER',to_date('8/9/2007','MM/DD/YYYY'),to_date('9/17/2008','MM/DD/YYYY'),'kf29023',to_date('3/22/2008','MM/DD/YYYY'),'Mar
22 2008 12:06:55',' ',:FL,'YES','YES','NO','153622-titaneur-443-aco')";
@loginfo = ("101 112 119 101 105 115 116 111 111 108 342 420","221 112 114 116 107
48 52 119 116 105 117 420 240");
&connectDatabase(*loginfo);
do this here
$dbh->{dbd_verbose}=15;
$sth = $dbh->prepare($sql_stmt);
$sth->bind_param
(":FL",'-%3CBR%3E-%3CBR%3E-%3CBR%3test-%3CBR%3E-%3CBR%3E-%3CBR%3E-%3CBR%3E-%3CB-%3CBR%3E-%3CBR%3E-%3CBR-%3CBR%3E-%3CBR%3E-%3CBR%3test-1234-%3CBR%3E-%3CBR%3E-%3CBR%3test-%3CBR%3E-%3CBR%3E-%3CBR%3E-%3CBR%3E-%3CB-%3CBR%3E-%3CBR%3E-%3CBR-%3CBR%3E-%3CBR%3E-%3CBR%3test-1234-%3CBR%3E-%3CBR%3E-%3CBR%3test-%3CBR%3E-%3CBR%3E-%3CBR%3E-%3CBR%3E-%3CB-%3CBR%3E-%3CBR%3E-%3CBR-%3CBR%3E-%3CBR%3E-%3CBR%3test-1234-%3CBR%3E-%3CBR%3E-%3CBR%3test-%3CBR%3E-%3CBR%3E-%3CBR%3E-%3CBR%3E-%3CB-%3CBR%3E-%3CBR%3E-%3CBR-%3CBR%3E-%3CBR%3E-%3CBR%3test-1234-%3CBR%3E-%3CBR%3E-%3CBR%3test-%3CBR%3E-%3CBR%3E-%3CBR%3E-%3CBR%3E-%3CB-%3CBR%3E-%3CBR%3E-%3CBR-%3CBR%3E-%3CBR%3E-%3CBR%3test-1234-%3CBR%3E-%3CBR%3E-%3CBR%3test-%3CBR%3E-%3CBR%3E-%3CBR%3E-%3CBR%3E-%3CB-%3CBR%3E-%3CBR%3E-%3CBR-%3CBR%3E3test-1234',{ora_type
=> ORA_CLOB , ora_field=> COMMENTS});
$rv = $sth->execute || &WriteDie("Execute failed: $DBI::errstr");
$dbh->{dbd_verbose}=0;
$sth->finish;
&closeDatabase();
}
Thanks for your help