WinSQL » 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


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:

    DBMS_OUTPUT.PUT_LINE('Increasing pay');
    SET SAL = SAL + incBy
    WHERE EMPNO = eNum;

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

Posted by NIshant Bhandari on 8/28/10 2:05 AM

great sight for search ,koool

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?

Important: This area is reserved for useful tips. Therefore, do not post any questions here. Instead, use our public forums to post questions.


Social Media

Powered by