It's probably a quoting issue. Unless you provide the SQL, there's no specific help to be given. One thought though - if you send Oracle an empty string through a DBI placeholder it is evaluated as a NULL. For example: select count(*) from my_table where some_column = ? and the paramater to the execute is the empty string, $sth->execute(''), it is actually executed as select count(*) from my_table where some_column = NULL which will always return 0, since NULL != NULL (or more generally NULL != anything).

To summarise: it's probably a quoting issue. Try it without placeholders. Have a look in v$sql. Set client_trace_level = admin in your local sqlnet.ora. Turn on DBI tracing. There's loads you can do to isolate the problem

rdfield

In reply to Re: DBI Perl Oracle , returs less number of rows than actual number by rdfield
in thread DBI Perl Oracle , returs less number of rows than actual number by learn_forever

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.