You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for DBMS_OUTPUT


1 to 20 of 66 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Packages and Types Reference, 10g Release 1 (10.1)

61 DBMS_OUTPUT

Using DBMS_OUTPUTSecurity Model Types Operational Notes Exceptions Deprecated Subprograms Examples

Packages and Types Reference, 10g Release 1 (10.1)

61 DBMS_OUTPUT

61 DBMS_OUTPUTThe 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

Packages and Types Reference, 10g Release 1 (10.1)

61 DBMS_OUTPUT

Summary of DBMS_OUTPUT SubprogramsTable 61-2  DBMS_OUTPUT Package Subprograms Subprogram Description DISABLE Procedure Disables

User's Guide and Reference, 10g Release 1 (10.1)

9 Using PL/SQL Packages

About the DBMS_OUTPUT PackagePackage DBMS_OUTPUT enables you to display output from PL/SQL blocks and subprograms, which makes

Packages and Types Reference, 10g Release 1 (10.1)

61 DBMS_OUTPUT

ParametersTable 61-8 PUT and PUT_LINE Procedure Parameters Parameter Description item Item to buffer.

Packages and Types Reference, 10g Release 1 (10.1)

61 DBMS_OUTPUT

SyntaxDBMS_OUTPUT.PUT (item IN VARCHAR2); DBMS_OUTPUT.PUT (item IN NUMBER);

Packages and Types Reference, 10g Release 1 (10.1)

61 DBMS_OUTPUT

SyntaxDBMS_OUTPUT.PUT_LINE (item IN VARCHAR2); DBMS_OUTPUT.PUT (item IN NUMBER);

Packages and Types Reference, 10g Release 1 (10.1)

61 DBMS_OUTPUT

PUT_LINE ProceduresThis 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.

Packages and Types Reference, 10g Release 1 (10.1)

61 DBMS_OUTPUT

ENABLE Procedureprocedures are ignored if the DBMS_OUTPUT package is not enabled.

Packages and Types Reference, 10g Release 1 (10.1)

61 DBMS_OUTPUT

ExamplesExample 1: Debugging Stored Procedures and Triggers The DBMS_OUTPUT package is commonly used to

Packages and Types Reference, 10g Release 1 (10.1)

61 DBMS_OUTPUT

ExceptionsTable 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.

Packages and Types Reference, 10g Release 1 (10.1)

61 DBMS_OUTPUT

GET_LINE ProcedureThis procedure retrieves a single line of buffered information.

Packages and Types Reference, 10g Release 1 (10.1)

61 DBMS_OUTPUT

SyntaxDBMS_OUTPUT.GET_LINE ( line OUT VARCHAR2, status OUT INTEGER);

Packages and Types Reference, 10g Release 1 (10.1)

61 DBMS_OUTPUT

DISABLE ProcedureThis 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.

Packages and Types Reference, 10g Release 1 (10.1)

61 DBMS_OUTPUT

Usage Notescaller. 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

Packages and Types Reference, 10g Release 1 (10.1)

61 DBMS_OUTPUT

ExceptionsTable 61-4 ENABLE Procedure Exceptions Error Description ORA-20000:, ORU-10027: Buffer overflow, limit of bytes.

Packages and Types Reference, 10g Release 1 (10.1)

61 DBMS_OUTPUT

GET_LINES ProcedureThis procedure retrieves an array of lines from the buffer.

Packages and Types Reference, 10g Release 1 (10.1)

61 DBMS_OUTPUT

ParametersTable 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.

Packages and Types Reference, 10g Release 1 (10.1)

61 DBMS_OUTPUT

SyntaxDBMS_OUTPUT.GET_LINES ( lines OUT CHARARR, numlines IN OUT INTEGER);

Packages and Types Reference, 10g Release 1 (10.1)

61 DBMS_OUTPUT

ParametersTable 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