How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
Using DBMS_OUTPUT → Security Model Types Operational Notes Exceptions Deprecated Subprograms Examples
61 DBMS_OUTPUT → The DBMS_OUTPUT package enables you to send messages from stored procedures, packages, and triggers … contains the following topics: Using DBMS_OUTPUT Security Model Types Operational Notes Exceptions … Deprecated Subprograms Exceptions Summary of DBMS_OUTPUT Subprograms
Summary of DBMS_OUTPUT Subprograms → Table 61-2 DBMS_OUTPUT Package Subprograms Subprogram Description DISABLE Procedure Disables
About the DBMS_OUTPUT Package → Package DBMS_OUTPUT enables you to display output from PL/SQL blocks and subprograms, which makes
Parameters → Table 61-8 PUT and PUT_LINE Procedure Parameters Parameter Description item Item to buffer.
Syntax → DBMS_OUTPUT.PUT (item IN VARCHAR2); DBMS_OUTPUT.PUT (item IN NUMBER);
Syntax → DBMS_OUTPUT.PUT_LINE (item IN VARCHAR2); DBMS_OUTPUT.PUT (item IN NUMBER);
PUT_LINE Procedures → This procedure places a partial line in the buffer. Note: The PUT_LINE procedure that takes a NUMBER is obsolete and, while currently supported, is included in this release for legacy reasons only.
ENABLE Procedure → procedures are ignored if the DBMS_OUTPUT package is not enabled.
Examples → Example 1: Debugging Stored Procedures and Triggers The DBMS_OUTPUT package is commonly used to
Exceptions → Table 61-7 NEW_LINE Procedure Exceptions Error Description ORA-20000, ORU-10027: Buffer overflow, limit of bytes. ORA-20000, ORU-10028: Line length overflow, limit of 255 bytes for each line.
GET_LINE Procedure → This procedure retrieves a single line of buffered information.
Syntax → DBMS_OUTPUT.GET_LINE ( line OUT VARCHAR2, status OUT INTEGER);
DISABLE Procedure → This procedure disables calls to PUT, PUT_LINE, NEW_LINE, GET_LINE, and GET_LINES, and purges the buffer of any remaining information. As with ENABLE, you do not need to call this procedure if you are using the SERVEROUTPUT option of Enterprise Manager or SQL*Plus.
Usage Notes → caller. For example, Enterprise Manager or SQL*Plus do not display DBMS_OUTPUT messages until the PL … /SQL program completes. There is no mechanism for flushing the DBMS_OUTPUT buffers within the PL/SQL
Exceptions → Table 61-4 ENABLE Procedure Exceptions Error Description ORA-20000:, ORU-10027: Buffer overflow, limit of bytes.
GET_LINES Procedure → This procedure retrieves an array of lines from the buffer.
Parameters → Table 61-5 GET_LINE Procedure Parameters Parameter Description line Returns a single line of buffered information, excluding a final newline character: The maximum length is 255 bytes. status If the call completes successfully, then the status returns as 0. If there are no more lines in the buffer, then the status is 1.
Syntax → DBMS_OUTPUT.GET_LINES ( lines OUT CHARARR, numlines IN OUT INTEGER);
Parameters → Table 61-6 GET_LINES Procedure Parameters Parameter Description lines Returns an array of lines of buffered information. CHARARR is a table of VARCHAR2 (255). The maximum length of each line in the array is 255 bytes. numlines Number of lines you want to retrieve from the buffer. After retrieving the specified number of lines, the procedure returns the number of lines actually retrieved. If this