Re: HELP HELP HELP! Simple PL/SQL Problem !!!!?????

From: Nathan D. Hughes <nhughes_at_well.com>
Date: 1997/12/18
Message-ID: <67a1mh$cja$1_at_was.hooked.net>#1/1


tkyte_at_us.oracle.com (Thomas Kyte) writes:

>On 17 Dec 1997 15:22:02 GMT, "Markus" <zm86_at_dial.pipex.com> wrote:
 [...]
>>control totals at the end of the run. Can anyone tell me how to display a
>>message on the screen?? I do not seem to be able to find any type of
>>display command!!
 [...]
>Your pl/sql routine can use the dbms_application_info package available with
>O7.2 and up. Using this package, you can write immediate messages into the
>v$session table. You control 3 fields in this system table --

Maybe dbms_output is what you're looking for. Look at dbms_output.enable, dbms_output.put_line, and dbms_output.disable. Just take note of the buffer limit.

--

Nathan D. Hughes <nhughes_at_well.com>
Computer Consultants of America, Inc.
Received on Thu Dec 18 1997 - 00:00:00 CET

Original text of this message