Re: How to display # of rows updated in a procedure?
From: N.Prabhakar <prabhs_at_pacific.net.sg>
Date: 1996/12/10
Message-ID: <58j4c2$npl_at_newton.pacific.net.sg>#1/1
Date: 1996/12/10
Message-ID: <58j4c2$npl_at_newton.pacific.net.sg>#1/1
"Jacques Jordan" <Jacques.Jordan_at_quickmail.llnl.gov> writes: > Does anyone know how to display the number of rows updated in an Update
> statement which is executed from a procedure? Is there a implicit cursor
> variable that stores the number of rows updated?
>
> T.I.A.
>
> Jacques.Jordan_at_quickmail.llnl.gov
Hi there,
use sql%rowcount.
Regards
N.Prabhakar Received on Tue Dec 10 1996 - 00:00:00 CET