Unable To Solve Syntax Error....
723451Sep 21 2009 — edited Sep 21 2009Hi:
I am writing following pl/sql script but i am getting syntax errors:
DECLARE
CURSOR comp_cur IS select bank_id,date_created,created_by,modified_by,name from COM_BANK_MASTER
comp_rec COM_BANK_MASTER %ROWTYPE;
BEGIN
OPEN comp_cur;
FETCH comp_cur INTO comp_rec;
WHILE comp_rec%FOUND
LOOP
dbms_output.put_line(comp_rec.name);
End LOOP;
close comp_cur;
END;
Then I write another script like,
declare
cursor comp_cur is select bank_id,date_created,created_by,modified_by,name from COM_BANK_MASTER
begin
for aa in c1;
Loop
dbms_output.put_line(aa.name);
end Loop;
end;
It also getting syntax error.
Can any body help me?
Thank You.