in reply to Oracle BLOB Locator
You already know where your error lies. What have you tried so far?
I bet your $fil will be uninitialized, therefore you can not bind your locator.
Why? You're trying to dereference a dereferenced hash value as a scalar value.
Try
$fil = $hashref->{IMP_IMAGE};
or
$fil = ${$hashref}{IMP_IMAGE};
Turning on strict would have told you.
In Section
Seekers of Perl Wisdom