3. Without the "_cached", it does not seems to change anything.....

I used DBI->trace as Arguile wisely suggested, and it looks like all is fine... strange...
The Statement is prepared, the parameter binded, and the all thing is executed successfully.
BUT it returns nothing ([0] items).

if I cut and paste the SQL from the Perl, and replace the :mob and :acc by the binded values in the log file, it returns the value fine (the entrie does exist in the table...).

Maybe I look for an error in the Perl when I should go and seek the wisdom of the DBA Administrator as he might have error log of my activities....

In reply to Re: Re: Code useless, forget it... this is more usefull (o; by Eric.D
in thread prepare_cached for DBI::Oracle 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.