Friday, October 12, 2012

Display the output of oracle procedure

I wrote a simple sample like:

DECLARE
    hello varchar(10);
BEGIN
    dbms_output.put_line('Hello World');

END;
/

When I run it on sqlplus, it showed: PL/SQL procedure successfully completed. Nothing else.

The solution is:

sqlplus> set serveroutput on

Then you can see the output.

No comments:

Post a Comment