Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?

DBD Clob insert : ORA 4043

by apaddobs (Initiate)
on Jul 30, 2012 at 03:18 UTC ( #984337=perlquestion: print w/replies, xml ) Need Help??
apaddobs has asked for the wisdom of the Perl Monks concerning the following question:

DBD ERROR: Can't match some parameters to LOB fields in the table, check type and name DBD::Oracle::st execute failed: ORA-04043: object family_records doesn't exist. There are 3 blob datatypes in the table.
my $st = "insert into family_records (name,dadname,momname,myhisto ry,mom history,dadhistory) values (:name,:dadname,:momname,:myhistory ,:momhistory,:dadhistory)"; $stmt = $dbh->prepare($st); $stmt->bind_param(":name", $name); $stmt->bind_param(":dadname", $dadname); $stmt->bind_param(":momname", $momname); $stmt->bind_param(":myhistory", "$myhistory", {ora_type => 113, or a_field =>"MYHISTORY" }); $stmt->bind_param(":dadhistory", "$dadhistory", {ora_type => 113, ora_field =>"DADHISTORY" }); $stmt->bind_param(":momhistory", "$momhistory", {ora_type => 113, ora_field =>"MOMHISTORY" }); $dbh->commit(); $stmt->finish(); $dbh->disconnect();
SQL> desc family_records Name Null? Type ----------------------------------------- NAME VARCHAR2(100) DADNAME VARCHAR2(100) MOMNAME VARCHAR2(100) MYHISTORY BLOB MOMHISTORY BLOB DADHISTORY BLOB
I do have the privileges to update/insert/modify the table. So there are no privileges issue.

Replies are listed 'Best First'.
Re: DBD Clob insert : ORA 4043
by mje (Curate) on Jul 30, 2012 at 09:43 UTC

    In your insert the column mom history has a space in it. Did you mean "mom history" or "momhistory" like the "dadhistory" and "myhistory".

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://984337]
Approved by GrandFather
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (3)
As of 2018-05-26 06:24 GMT
Find Nodes?
    Voting Booth?