in reply to Re^2: Query works in sqlplus but not DBI
in thread Query works in sqlplus but not DBI - Solved

How do you try to determine the number of rows that DBI returned?

The DBI manpage says

A successful "execute" always returns true regardless of the number of rows affected, even if it’s zero
...
For "SELECT" statements, execute simply "starts" the query within the database engine. Use one of the fetch methods to retrieve the data after calling "execute". The "execute" method does not return the number of rows that will be returned by the query (because most databases can’t tell in advance), it simply returns a true value.
  • Comment on Re^3: Query works in sqlplus but not DBI

Replies are listed 'Best First'.
Re^4: Query works in sqlplus but not DBI
by shadowfae (Initiate) on Feb 29, 2008 at 14:58 UTC
    The return value is "0E0" which means zero but true, but only for non-select queries!!! That's my mistake. For a select query it doesn't mean that. The problem was in a binding later!! Thank you so much. I misread the documentation on that.
[reply]

In Section Seekers of Perl Wisdom