![]() The dbmsotpt.sql script must be run as user SYS. In this way, you can design your application so that subprograms are available only when a client is able to process the information. If the package is disabled, all calls to subprograms are ignored. In a separate PL/SQL procedure or anonymous block, you can display the buffered information by calling the GET_LINE Procedure and GET_LINES Procedure. ![]() The PUT Procedure and PUT_LINE Procedure in this package enable you to place information in a buffer that can be read by another trigger, procedure, or package. The package is typically used for debugging, or for displaying messages and reports to SQL*DBA or SQL*Plus (such as are produced by applying the SQL command DESCRIBE to procedures). This section contains topics which relate to using the DBMS_OUTPUT package.
0 Comments
Leave a Reply. |