Re: Record count within a procedure

SQL%rowcount
<cursorname>%rowcount

RTFM the PL/SQL Users Guide and Reference, available at tahiti.oracle.com

Jared

Read the Application
On Monday 21 October 2002 14:23, Smith, Ron L. wrote:
> Within an update or load procedure, is there any way to return the
> transaction count for the number
> of rows affected? Kind of like the Feedback / NoFeedback option of
> SQL*PLUS?
>
> Thanks!
> R. Smith
> If you are not the intended recipient of this e-mail message, any use,
> distribution or copying of the message is prohibited. Please let me know
> immediately by return e-mail if you have received this message by mistake,
> then delete the e-mail message. Thank you.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).