in pro*c I'd use SQLCA ....
does SQL%ROWCOUNT have what you need.
"Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message
news:avju03$gp0dd$1_at_ID-152732.news.dfncis.de...
> Hello,
>
> I think, everybody here has seen success messages like "22 rows inserted"
> from SQL*Plus.
>
> Now: is there any method to get those messages into a varchar2-variable of
a
> PL/SQL?
> A member of my team tried something with dbms_output.get_line,
> but not successfully.
>
> It is _not_ about _error mesages_, which could be caught by SQLERRM.
> It is the "success mesages" that are of interest.
>
> Background is, we want to use it in Oracle Forms (donīt worry, I wonīt
> crosspost this ...),
> and those messages in Forms seem to be hidden or deleted - I am a
developer
> only as my second role ...
>
> Any comments or tips are greatfully appreceated.
>
> Jan
>
>
>
Received on Thu Jan 09 2003 - 08:24:32 CST
