#!/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->errstr;
$sth->bind_param(1, $updated_value, {ora_type => ORA_BLOB});
$sth->execute() or die $dbh->errstr;