I am not getting the input for my code, the procedure compiled but i am not getting any result what I supposed to get, Please take a look at my code and fix it Thank you,

SET SERVEROUTPUT ON;

CREATE OR REPLACE PROCEDURE generate$\_$job$\_$alerts $($

v$\_$jobid IN NUMBER,

v$\_$timestamp IN TIMESTAMP

$)$

AS

$--$ Cursor to find the job post and check if it is active

CURSOR cur$\_$job$\_$post IS

SELECT min$\_$degree, min$\_$years$\_$work$\_$exp, jobid

FROM job$\_$post

WHERE jobid $=$ v$\_$jobid AND j$\_$status $=1$;

$--$ Cursor to find job seekers who meet the degree and work experience requirements

CURSOR cur$\_$job$\_$seekers $($

p$\_$degree NUMBER,

p$\_$experience NUMBER

$)$

IS

SELECT js$.$accid, at$.$username

FROM js$\_$account js

JOIN account$\_$t at ON js$.$accid $=$ at$.$accid

WHERE degree $>=$ p$\_$degree AND num$\_$yrs$\_$wrk$\_$xp $>=$ p$\_$experience;

$--$ Variables to hold job requirements

v$\_$min$\_$degree NUMBER;

v$\_$min$\_$years$\_$work$\_$exp NUMBER;

v$\_$job$\_$post$\_$id NUMBER;

$--$ Variables for checking skills

v$\_$skill$\_$count NUMBER;

flag INT;

BEGIN

OPEN cur$\_$job$\_$post;

FETCH cur$\_$job$\_$post INTO v$\_$min$\_$degree, v$\_$min$\_$years$\_$work$\_$exp, v$\_$job$\_$post$\_$id;

IF cur$\_$job$\_$post$\%$NOTFOUND THEN

DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$Invalid job post ID$\text{'})$;

CLOSE cur$\_$job$\_$post;

RETURN;

END IF;

$--$ Loop through all qualified job seekers

FOR r$\_$job$\_$seeker IN cur$\_$job$\_$seekers$($v$\_$min$\_$degree, v$\_$min$\_$years$\_$work$\_$exp$)$ LOOP

flag :$=1$;

$--$ Check each required skill and level

FOR r$\_$skill IN $($

SELECT js$.$skid, js$.$sklvl

FROM job$\_$skills js

WHERE js$.$jobid $=$ v$\_$job$\_$post$\_$id

$)$ LOOP

SELECT COUNT$(*)$

INTO v$\_$skill$\_$count

FROM app$\_$skills aps

WHERE aps.accid $=$ r$\_$job$\_$seeker.accid AND aps.skid $=$ r$\_$skill.skid AND aps.sklvl $>=$ r$\_$skill.sklvl;

IF v$\_$skill$\_$count $=0$ THEN

flag :$=0$;

EXIT;

END IF;

END LOOP;

IF flag $=1$ THEN

$--$ If all conditions are met, print and insert into message table

DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$A job post $\text{'}||$ v$\_$job$\_$post$\_$id $||\text{'}$ is available and you are qualified to apply'$)$;

INSERT INTO message $($mid$,$ appid, mtime, mbody$)$

VALUES $($message$\_$seq.nextval, r$\_$job$\_$seeker.accid, v$\_$timestamp, 'A job post $\text{'}||$ v$\_$job$\_$post$\_$id $||\text{'}$ is available and you are qualified to apply'$)$;

END IF;

END LOOP;

CLOSE cur$\_$job$\_$post;

END;

$/$

BEGIN

generate$\_$job$\_$alerts$($v$\_$jobid $=>1,$ v$\_$timestamp $=>$ SYSTIMESTAMP$)$;

END;generate$\_$job$\_$alerts$($v$\_$jobid $=>1,$ v$\_$timestamp $=>$ SYSTIMESTAMP$)$;

END;

Script Output

Task completed in $0\mathrm{.}329$ seconds

Procedure GENERATE$\_$JOB$\_$ALERTS compiled

Invalid job post ID

PL$/$SQL procedure successfully completed.