DBMS_OUTPUT.PUT_LINE is unavoidable tool for an Oracle developer to debug issues. We must issue a sqlplus comman "SET SERVEROUT ON" to see the output from the above function in our console. By default it is off and we must issue the command explicitly to turn it on. Here is a small trick to turn it on by default.
1. Open login.sql/glogin.sql from SQL_PATH. (Search or grep for that file in the directory you have installed sqlplus.)
2. Add SET SERVEROUT ON command to that file.
Thats it. glogin.sql/login.sql will be executed every time you open a new sqlplus session.
Subscribe to:
Post Comments (Atom)
1 comment:
Thank's, That was of great help to me.
Post a Comment