Slightly OT: Perl and PL/SQL Cursor Question

From: mohammed bhatti <mkb125_at_yahoo.com>
Date: Tue, 02 Oct 2001 11:51:44 -0700
Message-ID: <F001.0039F47D.20011002113034@fatcity.com>

In PL/SQL, if I need to know if I've fetched the last row, I can do this:
IF recCursor%NOTFOUND THEN

   ...
   ...
END IF; How would I do this in Perl? Looking at the DBI docs, there does not seem to be a similar method. It suggests doing a COUNT(*) or possibly use the following:
$hash_ref = $sth->fetchall_hashref('id');

So, any similar functionality to %NOTFOUND in Perl?

tia

mkb

---

Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: mohammed bhatti
  INET: mkb125_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Oct 02 2001 - 13:51:44 CDT