Re: Get Updatecount in Stored Procedure

From: Marc Mazerolle <informaze_at_sympatico.ca>
Date: Wed, 02 Jun 1999 13:54:09 GMT
Message-ID: <375538AF.541B1452@sympatico.ca>

After an update, you can check "%rowcount" to get the number of rows updated. Note that you will NOT get an exeption when no rows are found for the update but %rowcount will be set to 0.

Regards,

Marc Mazerolle
InforMaze Inc.

Sam Jordan wrote:

> Hi
>
> I have a stored procedure which updates a table. How can I find out
> whether the update was successful or whether zero rows were inserted?
> SQLPlus usually prints out the amount of rows updated. I would like
> to get a similar information in my stored procedure.
>
> I'm using Oracle 8.0.5 for Linux.
>
> bye
> --
> Sam Jordan
Received on Wed Jun 02 1999 - 08:54:09 CDT