Debug stored Procedures in Oracle

oracle| Stored Procedures
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"