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

Thank You for Your input, but %ROWCOUNT
is not really what I mean, because (afaik) it can only be used in a cursor.

Now imagine a PU in Forms that is inserting without a cursor, just like

...
IF something_special
THEN
    INSERT INTO my_table
END IF;
IF something_other
THEN
    UPDATE my_table
    ...
    WHERE condition
END IF; and that is called maybe by a WHEN-BUTTON-PRESSED-trigger.

In SQL*Plus, normal messages would be shown - but in Forms not. Or is there a property setting that we oversee ?

"Telemachus" <telemachus_at_ulysseswillreturn.net> schrieb im Newsbeitrag news:BCfT9.1867$V6.2452_at_news.indigo.ie...
> 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 Fri Jan 10 2003 - 02:45:05 CST