create or replace procedure list_job_applications(v_job_id NUMBER)
IS  
cursor c1 is select IS  v_job_id
from accounts a, job_app ja, job_seekser js, skill s, job_seeker_skills jss
where a.accid = js.accid and a.accid = ja.accid and ja.accid = jss.accid and jss.sid = s.sid;
v_count int;
begin
select count(*) into v_count from job_posts where job_id =v_job_id;
if v_count = 0 then
dbms_output.put_line('Invalid job post ID');
 else
for item in c1 loop
        dbms.out.put_line('Account ID: ' || a.accid);
        dbms.out.put_line('Name: ' || a.acc_holder_name);
        dbms.out.put_line('Application Date: ' || TO_CHAR(a.application_date, 'DD-MON-YYYY'));
        dbms.out.put_line('Highest Degree: ' || js.highest_degree);
        dbms.out.put_line('Work Experience (Years): ' || js.years_exp);
        dbms.out.put_line('Skill: ' || sskill_name || ', Level: ' || jss.skill_level);
end loop;
end if;
end;
/

I am currently working on a problem that list all applications to a particular job post where the input is a job post ID. The objective is to check whether or not the input is valid and if it is it will list items such as the job, account ID, name, application date, highest degree, number of years work experience, name of skill and skill levels of each applicant.

enter image description here
Currently I am getting errors such as “3/14 PL/SQL: SQL Statement ignored” and “3/21 PL/SQL: ORA-00936: missing expression”. I am not sure what would make the code work. Any help would be great!your text