Knowledge Base

Document information

Document ID:	771
Subject:	Using functions in DBMS_OUTPUT package in ODBC
Creation date:	7/29/09 3:01 PM
Last modified on:	7/29/09 3:09 PM

Details

DBMS_OUTPUT is useful for debugging PL/SQL programs. One can use the DBMS_OUTPUT package to write information to an output buffer. For example:

CREATE OR REPLACE PROCEDURE "SCOTT"."PAYRAISE" (eNum IN NUMBER, incBy IN NUMBER)
AS
BEGIN
    DBMS_OUTPUT.PUT_LINE('Increasing pay');
    UPDATE EMP
    SET SAL = SAL + incBy
    WHERE EMPNO = eNum;
END;

WinSQL automatically calls DBMS_OUTPUT.GET_LINE function when there is data available in the buffer. Contents of this buffer are displayed in the result window.

User comments

Add a comment to this document

Do you have a helpful tip related to this document that you'd like to share with other users? Please add it below. Your name and tip will appear at the end of the document text.

Your name:
Your email:	Hide my email address
Verification code:	Enter the verification code you see above more submitting your tip
Tip:	Please limit tips to 1000 characters