Re: [DBI-Users] (Fwd) Problems inserting into a CLOB field type using DBI PERL

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

hello ash

Tim Bunce wrote:
[...]
> $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";
[...]
> The bind code for the CLOB field is:
> $Statement3->bind_param(53, $Data, {ora_type => ORA_CLOB, ora_field =>
'request_notes'})
[...]
> [Mon Apr 26 12:19:04 2010] [error] [client 130.88.157.213] Can't bind
> unknown placeholder ':p53' (53)

the sql statement contains only 52 columns and 52 placeholders.
request_notes is number 52.

greetings
hermann
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkvYKxwACgkQpZ4QdpzGMxwd+ACfY7u9pL4rSjgIL6xnawh2JShB
YLwAoMYua1nFO1LeyYgY7rQ4HkyO4GA7
=RdAF
-----END PGP SIGNATURE-----