Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

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.

Comment on DBD Clob insert : ORA 4043
Select or Download Code
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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://984337]
Approved by GrandFather
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (13)
As of 2015-07-07 18:48 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (93 votes), past polls