omm
Advanced Member | Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору
Из описания пакета DBMS_OUTPUT
------------
-- OVERVIEW
--
-- These procedures accumulate information in a buffer
-- (via "put" and "put_line") so that it can be retrieved
-- out later (via "get_line" or "get_lines"). If this
-- package is disabled then all calls to this package are
-- simply ignored. This way, these routines are only
-- active when the client is one that is able to deal
-- with the information. This is good for debugging, or
-- SP's that want to display messages or reports
-- to sql*dba or plus (like 'describing procedures', etc.).
-- The default buffer size is 20000 bytes. The
-- minimum is 2000 and the maximum is 1,000,000
...
-- SQL*DBA and SQL*PLUS, for instance, implement a
-- 'SET SERVEROUTPUT ON' command so that they know
-- whether to make calls to get_line(s) after issuing
-- insert, update, delete or anonymous PL/SQL calls
-- (these are the only ones that can cause triggers or
-- stored procedures to be executed).
...
procedure put_line(a varchar2);
pragma restrict_references(put_line,WNDS,RNDS);
procedure put_line(a number);
pragma restrict_references(put_line,WNDS,RNDS);
-- Put a piece of information in the buffer followed by
-- an end-of-line marker. When retrieved by get_line(s),
-- the number and date items will be formated with
-- to_char using the default formats. If you
-- want another format then format it explicitly.
-- get_line(s) return "lines" as delimited by "newlines".
-- So every call to put_line or new_line will generate a
-- line that will be returned by get_line(s).
-- Input parameters:
-- a
-- Item to buffer
-- Errors raised:
-- -20000, ORU-10027: buffer overflow, limit of
-- <buf_limit> bytes.
-- -20000, ORU-10028: line length overflow, limit
-- of 255 bytes per line.
...
|
