Re: Any way to get the normal feedback messages into a variable ?

Home -> Community -> Usenet -> c.d.o.server -> Re: Any way to get the normal feedback messages into a variable ? - solved. Thank You

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Fri, 10 Jan 2003 15:06:19 +0100
Message-ID: <avmk2k$hdqu5$1@ID-152732.news.dfncis.de>

"Holger Baer" <holger.baer_at_science-computing.de> schrieb im Newsbeitrag news:3E1E8F34.1030901_at_science-computing.de...
> Jan Gelbrich wrote:
> > Thank You for Your input, but %ROWCOUNT
> > is not really what I mean, because (afaik) it can only be used in a
cursor.
>
> And that's exactly why Telemachus told you to use SQL%ROWCOUNT. If you
> don't have an explicit cursor, you always have SQL...
>

Yes, and my fellow tested SQL%ROWCOUNT successfully meanwhile ... Thank You all / Danke Vielmals.

Jan

> Example:
>
> SQL> begin
> 1> update svcent set bid=bid;
> 2> dbms_output.put_line ('No of rows updated: ' || SQL%ROWCOUNT );
> 3> end;
> 4> /
>
> No of rows updated: 13
>
> PL/SQL-Prozedur wurde erfolgreich abgeschlossen.
>
> Regards
>
> Holger
>
Received on Fri Jan 10 2003 - 08:06:19 CST