Re: UPDATE
From: <j.m.whitehead_at_sheffield.ac.uk>
Date: Wed, 23 Aug 2000 12:27:18 +0100
Message-ID: <39A3B516.9A467F07_at_sheffield.ac.uk>
Date: Wed, 23 Aug 2000 12:27:18 +0100
Message-ID: <39A3B516.9A467F07_at_sheffield.ac.uk>
>
> I would like to know if it is possible to have how many
> lines have been updated when an update has been executed
> with the sql statement UPDATE in a procedure or function.
>
Sure, simply check the value of SQL%ROWCOUNT, it should tell you haow many rows were affected by the update statement.
Jonathan Received on Wed Aug 23 2000 - 13:27:18 CEST