Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

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

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Thu, 9 Jan 2003 14:37:11 +0100
Message-ID: <avju03$gp0dd$1@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 - 07:37:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US