1 Replies - 4668 Views - Last Post: 28 July 2012 - 03:01 AM

#1 apaddobs  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 49
  • Joined: 16-May 12

Perl DBD: Insert into table / BLOB

Posted 28 July 2012 - 12:52 AM

SQL> desc family_report
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER(6)
NAME VARCHAR2(55)
REPORT1 BLOB
REPORT2 BLOB
SPOUSE_NAME VARCHAR2(55)

What should my $stmt look like if I want to insert all the above ($report1 and $report2 are contents of two files).

    $sqlStmt = "insert into family_report "
    my %attrib;
    $stmt->bind_param(":id", $id);
    $stmt->bind_param(":name", $name);
    $attrib{'ora_type'} = 113;
    $attrib{'ora_field'} = $report1_name;
    $stmt->bind_param(1,$report1_contents,\%attrib);



How do i bind 2 blob params?

Is This A Good Question/Topic? 0
  • +

Replies To: Perl DBD: Insert into table / BLOB

#2 apaddobs  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 49
  • Joined: 16-May 12

Re: Perl DBD: Insert into table / BLOB

Posted 28 July 2012 - 03:01 AM

Ok I seem to have figured that out.
xecute failed: ORA-04043: object family_report does not exist (DBD ERROR: Can't match some parameters to + LOB fields in the table, check type and name)

This worked fine till a week ago. I wonder if the database has been upgraded or some such thing. The DBD version is 1.23.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1