Revolving around the core of technology
|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:
CREATE OR REPLACE PROCEDURE "SCOTT"."PAYRAISE" (eNum IN NUMBER, incBy IN NUMBER)
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.
Posted by NIshant Bhandari on 8/28/10 2:05 AM
Do you have a helpful tip related to this document that you'd like to share with other users?