The create or replace procedure import_date_customer ()
Is

Cursor emp_cursor is
Select * from CUSTOMER_APPLY_RESTRICTS_NEW
WHERE id=1;
The begin
For c in emp_cursor loop
Dbms_output. Put_line (c.I D | | ', '| | c.L EGAL_PERSON | |', '| | c.I DENTITY_NO);
end loop;
end;

CodePudding user response:

The create or replace procedure import_date_customer
Is
The begin
For c in (select * from CUSTOMER_APPLY_RESTRICTS_NEW
WHERE id=1) loop
Dbms_output. Put_line (c.I D | | ', '| | c.L EGAL_PERSON | |', '| | c.I DENTITY_NO);
end loop;
end;

CodePudding user response:

No parameters of process, do not add ()