in reply to DBI and Oracle: Problem fetching ALL records.

A couple of questions --

  1. When you say 'completely stops', do you mean it crashes or otherwise errors out, or that the statement handle stop returning records, as if it's run out?
  2. If it's erroring out, what's the error message?
  3. What is the query? Oracle has its own way of limiting the number of returned rows, so you won't see a 'LIMIT 100' or similar, you'll see 'WHERE ROWNUM < 100' or similar.
  • Comment on Re: DBI and Oracle: Problem fetching ALL records.

Replies are listed 'Best First'.
Re^2: DBI and Oracle: Problem fetching ALL records.
by Trihedralguy (Pilgrim) on Jan 08, 2007 at 03:01 UTC
    It seems as if the statement handle stop returning rows. I dont have any LIMIT on my where ____ LIMIT... etc. There is no error messages, its just simplely not outputing past 100 rows.
[reply]
      I ran the script this morning through unix and it outputs everything correctly, something must be going wrong inbetween getting it from the server and putting it onto my page...Is there some sort of perl buffer that im viloating?
[reply]

        I doubt it, but without seeing any of your code, I have no idea.

[reply]

In Section Seekers of Perl Wisdom