How To Enable dbms_output in PL/SQL Developer

Question

I know it's a simple thing but I can't seem to find a solution, how do I enable dbms_output in PL/SQL Developer. From googling all I got was how to enable it in sql developer but thats not what I'm looking for... I thought it should be automatically enabled in PL/SQL Developer but for example this block outputs nothing for me.

declare
  v_sample employees.first_name%type;
begin
  select first_name 
  into v_sample
  from employees
  where employee_id = 100;

  dbms_output.put_line(v_sample);
end;

just issue SET SERVEROUTPUT ON at the beginning of your code(from the command line). Alternatively DBMS_OUTPUT.ENABLE() might be used also. (Have a look at the Output tab) — Barbaros Özhan
– Barbaros Özhan, Commented Dec 14, 2020 at 19:20
thanks for answer but I'm getting ORA-00922 missing or invalid option error on SERVEROUTPUT. Do you have idea why is it so? — Working Pickle
– Working Pickle, Commented Dec 14, 2020 at 19:30
that case is not used within SQL Window, but from the command line. Get rid of that and look at the Output tab please( or DBMS Output of Test window ). Do you see the result of the select statement ? — Barbaros Özhan
– Barbaros Özhan, Commented Dec 14, 2020 at 19:33

Jon Heller · Accepted Answer · 2020-12-14 20:45:37Z

3

By default, PL/SQL Developer automatically retrieves DBMS_OUTPUT and you don't have to do anything extra to retrieve it. You do not need to use a Command Window to see output. (And you should generally avoid the Command Window - it's a terrible way to program.)

Go to Configure --> Preferences --> Oracle --> Output, and ensure that the "Enabled" button is checked:

Another possibility is that the FIRST_NAME value is null and there is nothing to output. To avoid that confusion, I typically add a hard-coded value before outputting variables:

dbms_output.put_line('Name: ' || v_sample);

answered Dec 14, 2020 at 20:45

Jon Heller

37.1k6 gold badges84 silver badges150 bronze badges

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

Collectives™ on Stack Overflow

How To Enable dbms_output in PL/SQL Developer

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related