Print equivalent on Oracle PLSQL
When you开发者_Python百科 execute the following block in Oracle SQL Developer
set serveroutput on format wraped;
begin
DBMS_OUTPUT.put_line('the quick brown fox jumps over the lazy dog');
end;
You get the following response
anonymous block completed
the quick brown fox jumps over the lazy dog
I am basically trying to use PRINT so I can track progress in my PLSQL code.
How do I get rid of the uber-annoying anonymous block completed
?
set feedback off
should suppress the message
精彩评论