Oracle – SQL Developer – Anonymous Block Completed
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
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.
Thank you. I was really confused about “anynomous block completed”.
it’s good to know, it help you
View->Dbms output
worked for me.
Thank you…. it really helped me
it works fine…thanks lot……..
Gracias