Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP HELP HELP! Simple PL/SQL Problem !!!!?????
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 CST