More data Oracle Clusterware is version 11.1.0.7. SQL> desc smtools.sm_stg_tb; Name Null? Type ----------------------------------------- -------- ---------------------------- REQUEST_ID NOT NULL NUMBER(38) APP_STATUS NOT NULL VARCHAR2(50) WEB_URL VARCHAR2(255) APP_SERVERS VARCHAR2(255) WEB_PORT VARCHAR2(30) LDAP_GROUP VARCHAR2(30) SSL_SECURITY VARCHAR2(3) PROTECTED_URI CLOB UNPROTECTED_URI CLOB AGENT_NAME VARCHAR2(255) AGENT_COOKIES VARCHAR2(255) AGENT_HDRS VARCHAR2(255) AGENT_TIMEOUT VARCHAR2(10) STG_SERVERS VARCHAR2(255) ASSIGNED_TO VARCHAR2(30) SUBMITTED_DATE DATE LAST_UPDATED DATE LAST_UPDATED_BY VARCHAR2(10) COMP_DATE DATE COMPLETED_DATE VARCHAR2(20) PRIV_COMMENTS CLOB COMMENTS CLOB NOUSER VARCHAR2(3) FAILEDLOGIN VARCHAR2(3) UNAUTH VARCHAR2(3) APP_ID VARCHAR2(10) APP_SHORTNAME VARCHAR2(30) TOT_USERS NUMBER(38) TOT_ACTIVE_USERS NUMBER(38) AVG_DAILY NUMBER(38) MAX_DAILY NUMBER(38) MAX_PEAK_DAILY NUMBER(38) PEAK_MAX_CONCURRENT_USER NUMBER(38) PEAK_MAX_USERS NUMBER(38) PEAK_HOURS_START NUMBER(38) PEAK_HOURS_END NUMBER(38) AGENT_CONF CLOB AGENT_CONF_STATUS VARCHAR2(10) AGENT_CONFIG_OBJECT VARCHAR2(255) HOST_CONFIG_OBJECT VARCHAR2(255) AGENT_UPGRADE VARCHAR2(50) REMOTE_USER VARCHAR2(50) REMOTE_USER_VALUE VARCHAR2(50) SYS_ADMIN VARCHAR2(100) STATUS_55 VARCHAR2(50) CLEANUP46_STATUS VARCHAR2(50) APP_AGENT_PARAM CLOB POLICY_REGION VARCHAR2(10) AGENT_UPGRADE_6 VARCHAR2(10) COMMENTS_SAML CLOB TEST BLOB
GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRA HIE --------------- --------------- --------------- ------------------------------ ---------------------------------------- --- --- WEISTOOL SMTOOLS SM_STG_TB SMTOOLS DELETE NO NO WEISTOOL SMTOOLS SM_STG_TB SMTOOLS INDEX NO NO WEISTOOL SMTOOLS SM_STG_TB SMTOOLS INSERT NO NO WEISTOOL SMTOOLS SM_STG_TB SMTOOLS SELECT NO NO WEISTOOL SMTOOLS SM_STG_TB SMTOOLS UPDATE NO NO WEISTOOL SMTOOLS SM_STG_TB SMTOOLS REFERENCES NO NO 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 4:45 PM To: Lopez Mariz, Luis Fernando [BMX-BNAMEX] Cc: 'dbi-users@perl.org' Subject: RE: Help for insert query using DBD oracle Hi, What version of the client are you using and what version of DBD::Oracle are you using? What is the version of your oracle rac db? I've no problem inserting your text string into a simple table with a clob field in my 2 node rac instance. Michael On Wed, 3 Feb 2010, Lopez Mariz, Luis Fernando wrote: > Date: Wed, 3 Feb 2010 09:53:55 -0600 > From: "Lopez Mariz, Luis Fernando " > <luis.fernando.lopezma...@citi.com> > To: "'dbi-users@perl.org'" <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 > 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_SEC > URITY,PROTECTED_URI,UNPROTECTED_URI,AGENT_NAME,AGENT_COOKIES,AGENT_HDR > S,AGENT_TIMEOUT,STG_SERVERS,ASSIGNED_TO,SUBMITTED_DATE,LAST_UPDATED,LA > ST_UPDATED_BY,COMP_DATE,COMPLETED_DATE,PRIV_COMMENTS,COMMENTS,NOUSER,F > AILEDLOGIN,UNAUTH,AGENT_CONFIG_OBJECT) VALUES > (200700180011138,'COMPLETED','https://traderecords.europe.citigroup.ne > t','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); > $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"); > > > $sth->finish; > > > &closeDatabase(); > > } > Thanks for your help > -- ---//--- Time flies like the wind. Fruit flies like bananas. --- Groucho Marx Either write something worth reading or do something worth writing. --- Benjamin Franklin A meeting is an event at which the minutes are kept and the hours are lost
