DBD::Oracle doesn't come right out and say so, it does restrict the types you can bind. From the driver code (dbdimp.c), 
static int
oratype_bind_ok(dbtype)    /* It's a type we support for placeholders 
+*/
    int dbtype;
{
    /* basically we support types that can be returned as strings */
    switch(dbtype) {
    case  1:    /* VARCHAR2    */
    case  5:    /* STRING    */
    case  8:    /* LONG        */
    case 23:    /* RAW        */
    case 24:    /* LONG RAW    */
    case 96:    /* CHAR        */
    case 97:    /* CHARZ    */
    case 106:    /* MLSLABEL    */
    case 102:    /* SQLT_CUR    OCI 7 cursor variable    */
    case 112:    /* SQLT_CLOB / long    */
    case 113:    /* SQLT_BLOB / long    */
    case 116:    /* SQLT_RSET    OCI 8 cursor variable    */
    return 1;
    }
    return 0;
}

[download]
I'm guessing that NUMBER isn't on this list because Oracle's numbers are in a funky, multiple-byte packed fixed-point format. They won't necessarily fit into any of Perl's native types.

Bind a string instead. It'll be automagically converted.

In reply to Re: cant bind ORA_NUMBER in DBD::Oracle ? by dws
in thread cant bind ORA_NUMBER in DBD::Oracle ? by premjhere

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.