Hi, Many thanks for your assistance. Thank you for highlighting that John.
I have managed to fix the problem, I also needed to set the LongReadLen and LongTruncOk attributes which control how long columns are retrieved. I appreciate your support Wishing you all the best Ash -----Original Message----- From: John Scoles [mailto:sco...@pythian.com] Sent: 28 April 2010 13:36 To: arshad.mahm...@manchester.ac.uk; dbi-users@perl.org Subject: Re: (Fwd) Problems inserting into a CLOB field type using DBI PERL Nothing to DBI or DBD oracle Check your SQL statement you have only 52 '?' but you are trying to bind field 53 cheers John Scoles Tim Bunce wrote: > ----- Forwarded message from Arshad Mahmood > <arshad.mahm...@manchester.ac.uk> ----- > > Date: Mon, 26 Apr 2010 12:52:41 +0100 > From: Arshad Mahmood <arshad.mahm...@manchester.ac.uk> > To: Tim Bunce <tim.bu...@pobox.com> > Subject: Problems inserting into a CLOB field type using DBI PERL > X-Mailer: Oracle Connector for Outlook 10.1.3.0.10 100801 (11.0.5510) > > Hi Tim, > > I am doing some programming on a red hat linux env using DBI with perl and > trying to insert into an Oracle database and particularly a CLOB field. > > The perl version is perl, v5.8.8 built for x86_64-linux-thread-multi > The dbi version I am using is most likely the latest version of DBI > The oracle database I am using is 11g > > The CLOB field that I am inserting into is called "request_notes" > > > My code is below; > > $Sql3 = "INSERT into bas_aba_immediaterequests > (request_id,submitter,create_date,last_modified_by,modified_date,statu > s,short_description,requesters_name,requesters_email_address,managers_ > name,managers_email_address,roles,software,request_status_,user_id,tas > ks,ip_address,facultyschool,other,get_details_live_link_only,documents > _oracle_financials_on,budgetcode_oracle_financials_o,responsibility_or > acle_financia,responsibility_give_details_or,receive_reports_oracle_fi > nanci,ctrro_oracle_financials_only,desktop_set_up_complete,atacf,atacs > ,cc,fctn,ipn,req,sameas,fcas,please_give_details,location,training_com > plete,fwall_complete,usertel,mgrtel,checkrlhrauth1,checkrlhrauth2,wfif > u,csc,empno,purchasingunit,jobtitle,brrother,team,repbusinessarea,requ > est_notes) VALUES > (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? > ,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; > > $Statement3 = $Dbh->prepare($Sql3) or die "Can't > Prepare:$DBI::errstr\n"; > > Then I do the bind for each field > > The bind code for the CLOB field is: > $Statement3->bind_param(53, $Data, {ora_type => ORA_CLOB, ora_field => > 'request_notes'}) > > $Statement3->execute() || "Cannot Execute SQL Statement insert_sql > into its_servicedesk correspond: $DBI::errstr\n"; > > > I get the following error in the log files > > [Mon Apr 26 12:19:04 2010] [error] [client 130.88.157.213] Can't bind > unknown placeholder ':p53' (53) > > > Can you please assist as ive been stuck on this problem for quite a while > now.. > > Many Thanks > Ash > > > ----- End forwarded message ----- >
