It appears to be possible if you use placeholders (and hope your DBD driver supports it).
From the DBI documentation

     When trying to insert long or binary values, placeholders
     should be used since there are often limits on the maximum
     size of an (insert) statement and the the quote entry
     elsewhere in this documentmethod generally can't cope with
     binary data.  See the section on Placeholders and Bind
     Values.
[download]

Never tried it myself and don't have access to Oracle at present. For more information 'perldoc DBI' and perhaps this node

I could lie down like a tired child,
And weep away the life of care
Which I have borne, and yet must bear. Shelley 1792-1822