iSQL Plus: print to screen

Question

How do you enable iSQL*Plus terminal to print output to screen?

For instance a simple hello world block:

iSQL plus terminal

Note how "hello world" should be printed to screen, but only confirmation that there were no compilation errors is given.

score 1 · Accepted Answer · answered Apr 21 '13 at 14:54

1

You need enable dbms outout and set server output on.

exec dbms_output.enable(1000000);

and on top of your program paste this:

set serveroutput on

answered Apr 21 '13 at 14:54

Lokesh

Thank you. Why Oracle documentation did not seem to mention this is beyond me (or why it isn't enabled by default). – Stumbler Apr 21 '13 at 14:55
can't really say why it is not enabled by default. – Lokesh Apr 21 '13 at 14:56
you are able to see output now? – Lokesh Apr 21 '13 at 14:57

1 Answers1