I'm having some problems with DBD::Oracle in updating a CLOB column in a
table. Using the code below:
my $insert_text_sth = $dbh->prepare("UPDATE table SET long_column=? WHERE
id=$quoted_id");
$insert_text_sth->bind_param(1,$uc_document,{ora_type=>ORA_CLOB,ora_field=>'contents_text'});
my $success = $insert_text_sth->execute;
$success is true, and no errors or warnings are seen. However, the column in
question is never updated. I've done some searching on-line, and it's
unclear to me if updating a CLOB column is supported with DBD::Oracle. I've
tried:
1) Setting AutoCommit off and committing everything manually.
2) Every combination/variation that I can think of for the attributes in the
bind_param call.
However, neither of those seems to make a difference. If I issue the update
query in SQLPlus, the column is updated correctly. Also, INSERT statements
using CLOB column(s) seem to work fine. I'm a bit stumped right now as to
what's causing this...
-Shea Nangle
<[EMAIL PROTECTED]>
