Re: Getting the # of Rows in a Cursor
From: Gary Myers <101355.3556_at_CompuServe.COM>
Date: 1995/11/24
Message-ID: <4952gt$3ec$1_at_mhadf.production.compuserve.com>#1/1
Date: 1995/11/24
Message-ID: <4952gt$3ec$1_at_mhadf.production.compuserve.com>#1/1
Oracle (normally) won't supply all the rows for a cursor at once, so you would have to do a Count(*) first and work from that. If you are fetching into a host language array (eg in Pro*Cobol), and the entire set returned fits in that array, then the SQLERRD(3) value will be the number of rows returned.
-- Gary Myers, Analyst/Programmer, Kaisha Technology, West of EnglandReceived on Fri Nov 24 1995 - 00:00:00 CET