posted 19 years ago
plz do let me know why am i getting this error below is the code followed by the error msgs.
create or replace procedure dnsp is
cursor s1 is select splr.s_num, splr.s_name,
cnts.c_area_code,cnts.c_phone
from supplier splr, supplies spls,contacts cnts
where splr.s_num not in(select distinct spls.s_num from supplies
spls) and splr.s_num=cnts.s_num
order by splr.s_num;
l_num supplier.s_num%type :=0;
begin
DBMS_OUTPUT.PUT_LINE('No Purchases have been made from the
following supplier');
for cursor_r in s1 loop
if l_num != current_row.s_num then
DBMS_OUTPUT.PUT_LINE('Supplier'||current_row.s_name||'(number'||tochar(current_row.s_num)||')');
end if;
end loop;
end;
/
here is the error msgs...
LINE/COL ERROR
-------- -----------------------------------------------------------------
17/2 PL/SQL: Statement ignored
17/14 PLS-00201: identifier 'CURRENT_ROW.S_NUM' must be declared
plz do let me know wht mistake am i making in the above code as soon as possible thanks...