[apaddobs]

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?

[apaddobs]

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.