WinSQL » Knowledge base

Document information

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?

Your Name

Email

Hide my email address

Captcha

Your Tip

Submit Tip