Debug stored Procedures in Oracle

I do not know how to debug a stored procedure when I write it. One way to debug this is to print out the value of a variable in a program that I print on the console in Java. Here's how to do this from the Sqlplus.

1, execute "set serveroptput on" command on Sqlplus

2, in the stored procedure can use Dbms_output. Put_Line (VarName); To print out

Give an example of a stored procedure:

create or replace procedure test is
Emp_name　　VARCHAR2(10);
　 Cursor　　　c1 IS SELECT Ename FROM EMP
　　　　　　　　　WHERE Deptno = 20;
BEGIN
　 OPEN c1;
　 LOOP
　　　FETCH c1 INTO Emp_name;
　　　EXIT WHEN c1%NOTFOUND;
　　　DBMS_OUTPUT.PUT_LINE(Emp_name);
　 END LOOP;
end test;

The background creates test this stored procedure, compiles it, takes Scott/tiger account entry, executes set serveroptput on, and executes "exec test"