Psudo code

In Real Time Whenever we are going to write any program better write "Psudo code"

Example 

create or replace procedure XXINV_proc(P_inv_num varchar2)
is
cursor c1
is
select invoice_num
from ap_invoice_all
where invoice_num=p_invoice_num
begin
null
end;
===>>Then compile it, if at all  we don't get errors we can go ahead to write the program ...(its a Good practice For real time people) 


Now write the program and execute

create or replace procedure XXINV_proc(P_inv_num  varchar2)
is
cursor c1
is
select invoice_num
from ap_invoice_all
where invoice_num=p_invoice_num
begin
fori in c1
loop
null;
end loop;
exception
when others then
null;
end;
end;