Execute immediate dbms_output.put_line

Question

I have code like this:

set serveroutput on

declare
v_str varchar2(200);
begin
v_str := q'!dbms_output.put_line('Hello world');!';
Execute immediate v_str;
end;

Oracle SQL Developer says that there's invalid SQL Statement, what's the problem?

Is there a particular reason why you need to call dbms_output with dynamic PL/SQL? — Jeffrey Kemp
– Jeffrey Kemp, Commented Dec 19, 2012 at 4:10

wolφi · Accepted Answer · 2012-12-18 09:28:36Z

7

declare
v_str varchar2(200);
begin
v_str := q'!begin dbms_output.put_line('Hello world'); end;!';
Execute immediate v_str;
end;
/

works...

answered Dec 18, 2012 at 9:28

wolφi

8,3914 gold badges41 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Basically, the answer is that dbms_output is a procedure and so can only be executed within a PL/SQL block.

@Ben - really a reply to a comment on your deleted answer, but still relevant here; the q syntax is in the documentation under text literals.