in reply to Re: Counting number of rows while working with Oracle
in thread Counting number of rows while working with Oracle
The only way for the client to know how many rows will be returned is to count them as they're being read in.
The simplest solution would to read all the rows into memory before starting to process them.
Especially since you say your query will only return at most a single row, using fetchall_arrayref or the even more convenient selectall_arrayref should be no problem.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^3: Counting number of rows while working with Oracle
by ikegami (Patriarch) on Mar 18, 2008 at 08:16 UTC | |
by denzil_cactus (Sexton) on Mar 18, 2008 at 12:12 UTC | |
by andreas1234567 (Vicar) on Mar 18, 2008 at 12:24 UTC | |
by denzil_cactus (Sexton) on Mar 20, 2008 at 07:12 UTC | |
by denzil_cactus (Sexton) on Mar 18, 2008 at 11:02 UTC | |
by ikegami (Patriarch) on Mar 18, 2008 at 12:52 UTC | |
by andreas1234567 (Vicar) on Mar 18, 2008 at 11:42 UTC | |
by denzil_cactus (Sexton) on Mar 20, 2008 at 08:44 UTC |
In Section
Seekers of Perl Wisdom