This creates the public synonym DBMS_OUTPUT, and EXECUTE permission on this package is granted to public. 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. NOTE: for Oracle Database 10.2, you should request 10.2.0.1 even if you want to install a later patch set. To request access to these releases, follow the instructions in Oracle Support Document 1071023.1 (Requesting Physical Shipment or Download URL for Software Media) from My Oracle Support. Using warez version, crack, warez passwords, patches, serial numbers, registration codes, key generator, pirate key, keymaker or keygen for dbms oracle license key is illegal. Top 4 Download periodically updates software information of dbms oracle full versions from the publishers, but some information may be slightly out-of-date. This chapter contains the following topics: The package is especially useful for displaying PL/SQL debugging information. The DBMS_OUTPUT package enables you to send messages from stored procedures, packages, and triggers.
0 kommentar(er)
