----- 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,status,short_description,requesters_name,requesters_email_address,managers_name,managers_email_address,roles,software,request_status_,user_id,tasks,ip_address,facultyschool,other,get_details_live_link_only,documents_oracle_financials_on,budgetcode_oracle_financials_o,responsibility_oracle_financia,responsibility_give_details_or,receive_reports_oracle_financi,ctrro_oracle_financials_only,desktop_set_up_complete,atacf,atacs,cc,fctn,ipn,req,sameas,fcas,please_give_details,location,training_complete,fwall_complete,usertel,mgrtel,checkrlhrauth1,checkrlhrauth2,wfifu,csc,empno,purchasingunit,jobtitle,brrother,team,repbusinessarea,request_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 -----
