in reply to inserting text into a clob datatype
#!/usr/bin/perl use strict; use warnings; use DBD::Oracle ':ora_types'; # Set up any necessary Oracle ENV variables my $dbh = DBI->connect($conn_string, $user, $pass) or die $DBI::errstr +; my $sth = $dbh->prepare("UPDATE table SET field = ?") or die $dbh->err +str; $sth->bind_param(1, $updated_value, {ora_type => ORA_BLOB}); $sth->execute() or die $dbh->errstr;
Cheers - L~R
|
|---|