I am getting the following error: Compilation failed, line 14 PLS-00103: Encountered the symbol "CURSOR"
Here is my code. Please Tell me what I am doing incorrectly. Thank you.
create or replace procedure add_new_record
(p_row_id in varchar2,
p_last_name in varchar2,
p_first_name in varchar2,
p_middle_name in varchar2,
p_dob in date,
p_msu900 in varchar2,
p_ccdid in varchar2,
p_ucdid in varchar2,
p_compliant in varchar2,
p_lastupdate_id in varchar2,
p_last_update_date in date);
cursor p_cursor is
select * from immunization_db
order by row_id;
AS
BEGIN
OPEN p_cursor
SELECT * FROM immunization_db
WHERE row_id = p_row_id;
for i in p_cursor loop
dbms_output.put_line('ROW_ID: ' || i.p_row_id || 'LAST_NAME: '|| i.p_last_name || 'FIRST_NAME: '|| i.p_first_name ||
'MIDDLE_NAME: '|| i.p_middle_name || ' DOB: '|| i.p_dob || 'MSU900: ' || i.p_msu900 || 'CCIDID: '|| i.p_ccdid ||
'UCIDID: '|| i.p_ucdid || 'COMPLIANT: '|| i.p_compliant || 'LASTUPDATE_ID: '|| i.p_lastupdate_id || 'LASTUPDATE_DATE: '|| i.p_lastupdate_date);
end loop;
END;