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

In reply to Re: writting into databases by Jonathan
in thread writting into databases by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.