Dec 072011
 

Oracle SQL Developer does not display the output of DBMS_OUTPUT.PUT_LINE, it gives “anonymous block completed” in the script output tab

Some time we are confused why this is giving message “anonymous block completed”

To see the output of script, we need to enable DBMS_OUTPUT by clicking on plus symbol (see below in the snapshot) then we can see the output of script.

Example

Oracle - SQL Developer - Anonymous Block Completed

Oracle – SQL Developer – Anonymous Block Completed

 

Note:

Anonymous block

An ANONYMOUS BLOCK is a PL/SQL program that has no name and not stored in the database. It is generally used to test some of the programs.

Named blocks

Named blocks refer Procedures, Functions and Packages etc.

  • sandfervor

    Thank you. I was really confused about “anynomous block completed”.

  • http://twitter.com/Varinder_Sandhu Varinder Sandhu

    it’s good to know, it help you

  • Radek Manasek

    View->Dbms output
    worked for me.

  • Bhaskar Munukuntla

    Thank you…. it really helped me

  • vanitha

    it works fine…thanks lot……..

  • Desarrollo Escuintla

    Gracias