Why no output when PLSQL Anonymous block completes

2019-01-11 13:24发布

This question already has an answer here:

I'm just getting into PL/SQL, and I tried to run the following code, and I am getting anonymous block completed, but I think I should be getting Testing output. Does any know what I am doing wrong?

DECLARE
   message varchar2(20) := 'Testing output';
BEGIN
   dbms_output.put_line(message);
END;
/

标签: sql oracle plsql
7条回答
一夜七次
2楼-- · 2019-01-11 14:25

Yes. There is way to see output in SQL Developer.

Click ->View->Dbms Output and then click + symbol on Dbms output window. now you can run the procedure and can see output.

查看更多
登录 后发表回答