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 -> Re: HELP HELP HELP! Simple PL/SQL Problem !!!!?????

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@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 CST

Original text of this message

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