What is the DBMS_OUTPUT Oracle supplied package?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is the DBMS_OUTPUT Oracle supplied package?
Rating:
The DBMS_OUTPUT Oracle supplied package provides procedures that can be used to output values and messages from a PL/SQL block. This is done by accumulating information into a buffer and then allowing the retrieval of the information from the buffer. Every reference to the procedures of the DBMS_OUTPUT package must be qualified with the DBMS_OUTPUT prefix.
The DBMS_OUTPUT package enables developers to closely follow the execution of a subprogram (function or procedure) by sending messages and values to the output buffer. A subprogram can be debugged by specifying autonomous procedure calls and storing the output in a log table.
Rating:
Was this information helpful?
Other articles
- What is the syntax for creating a DDL trigger?
- What is object privilege?
- What is the syntax for creating a procedure?
- What is LOB?
- What is a BEFORE trigger?