Re: Re: DBI Perl Oracle , returs less number of rows than actual number

I tried both options
1. $sth->rows;
2. fetching all records and the using a counter to itearte through the array.

Both way I get max 30787 records.

Comment on Re: Re: DBI Perl Oracle , returs less number of rows than actual number

Replies are listed 'Best First'.
Re: Re: Re: DBI Perl Oracle , returs less number of rows than actual number by lachoy (Parson) on May 31, 2002 at 11:57 UTC
Only the second way will work. The first is for finding how many rows were affected by an UPDATE/DELETE operation. Since DBD::Oracle uses the same libraries as SQLPlus, that strongly leads me to look at some difference between the Perl invocation and the SQLPlus invocation: how the queries are constructed, who is creating the query, how are the results fetched. Also, what happens when you issue a `SELECT COUNT(*) FROM foo WHERE ...` in each of the environments? Chris M-x auto-bs-mode	[reply]

Replies are listed 'Best First'.

Re: Re: Re: DBI Perl Oracle , returs less number of rows than actual number
by lachoy (Parson) on May 31, 2002 at 11:57 UTC

Only the second way will work. The first is for finding how many rows were affected by an UPDATE/DELETE operation.

Since DBD::Oracle uses the same libraries as SQL*Plus, that strongly leads me to look at some difference between the Perl invocation and the SQL*Plus invocation: how the queries are constructed, who is creating the query, how are the results fetched.

Also, what happens when you issue a SELECT COUNT(*) FROM foo WHERE ... in each of the environments?

Chris
M-x auto-bs-mode

[reply]