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

Hi Jan,

sorry, it seems that our server doesn't have your original message. So here is
my humble addition. I created a little test form with a button and a w-b-p trigger
on it. In this trigger I issued things like 'Insert into test select * from test2' or
'update test set id = 2 where id < 6'. After the operations I caught the number
of processed rows with a statement like 'nAnz := SQL%ROWCOUNT'. Then I showes up a message in my form containing the nAnz value.

So: for me there is no problem. Did I get you wrong? If you want, you could e-mail me on this topic (in german, PLEASE ;-))

Grüßt: Guido

"Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> schrieb im Newsbeitrag news:avm18c$gof75$1_at_ID-152732.news.dfncis.de...
> 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 - 04:13:17 CST