Hi I am gfetting this error on my code, please help me$,$

LINE$/$COL ERROR

$----------------------------------------------------------------------$

$2/1$ PLS$-00103$: Encountered the symbol $""$ when expecting one of the following: current delete exists prior

Errors: check compiler logI AM SUBMITTING MY CODE HERE:

CREATE OR REPLACE PROCEDURE search$\_$job$\_$posts$($

$$p$\_$keyword IN VARCHAR$2,$

$$p$\_$job$\_$type IN INT,

$$p$\_$state IN VARCHAR$2$

$)$

AS

$$v$\_$count int ;

$$v$\_$job$\_$id JobPosts.JobID$\%$TYPE;

$$v$\_$company$\_$name Companies.CompanyName$\%$TYPE;

$$v$\_$title JobPosts.Title$\%$TYPE;

$$v$\_$description JobPosts.Descriptions$\%$TYPE;

$$v$\_$min$\_$pay JobPosts.MinAnnualPay$\%$TYPE;

$$v$\_$max$\_$pay JobPosts.MaxAnnualPay$\%$TYPE;

$$v$\_$city JobPosts.City$\%$TYPE;

$$v$\_$state JobPosts.States$\%$TYPE;

BEGIN$$

$$SELECT COUNT$(*)$ INTO v$\_$count

$$FROM JobPosts jp$,$ Companies c

$$WHERE jp$.$CompanyID $=$ c$.$CompanyID

$$AND jp$.$Status $=1$

$$AND jp$.$JobType $=$ p$\_$job$\_$type

$$AND jp$.$States $=$ p$\_$state

$$AND $($jp$.$Title LIKE $\text{'}\%\text{'}||$ p$\_$keyword $||\text{'}\%\text{'}$ OR jp$.$Descriptions LIKE $\text{'}\%\text{'}||$ p$\_$keyword $||\text{'}\%\text{'})$;

$$

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

$$DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$No job posts'$)$;

$$else

$--$ Search for job posts

$$FOR job$\_$rec IN $($SELECT jp$.$JobID,

$$c$.$CompanyName,

$$jp$.$Title,

$$jp$.$Descriptions,

$$jp$.$MinAnnualPay,

$$jp$.$MaxAnnualPay,

$$jp$.$City,

$$jp$.$States

$$FROM JobPosts jp$,$ Companies c

$$WHERE jp$.$CompanyID $=$ c$.$CompanyID

$$AND jp$.$Status $=1$

$$AND jp$.$JobType $=$ p$\_$job$\_$type

$$AND jp$.$States $=$ p$\_$state

$$AND $($jp$.$Title LIKE $\text{'}\%\text{'}||$ p$\_$keyword $||\text{'}\%\text{'}$ OR jp$.$Descriptions LIKE $\text{'}\%\text{'}||$ p$\_$keyword $||\text{'}\%\text{'}))$

$$LOOP

$--$ Fetch job details

$$v$\_$job$\_$id :$=$ job$\_$rec.JobID;

$$v$\_$company$\_$name :$=$ job$\_$rec.CompanyName;

$$v$\_$title :$=$ job$\_$rec.Title;

$$v$\_$description :$=$ job$\_$rec.Descriptions;

$$v$\_$min$\_$pay :$=$ job$\_$rec.MinAnnualPay;

$$v$\_$max$\_$pay :$=$ job$\_$rec.MaxAnnualPay;

$$v$\_$city :$=$ job$\_$rec.City;

$$v$\_$state :$=$ job$\_$rec.States;

$$

$--$ Print job details

$$DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$Job Post ID: $\text{'}||$ v$\_$job$\_$id$)$;

$$DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$Company Name: $\text{'}||$ v$\_$company$\_$name$)$;

$$DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$Job Title: $\text{'}||$ v$\_$title$)$;

$$DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$Description: $\text{'}||$ v$\_$description$)$;

$$DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$Min Annual Pay: $\text{'}||$ v$\_$min$\_$pay$)$;

$$DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$Max Annual Pay: $\text{'}||$ v$\_$max$\_$pay$)$;

$$DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$City: $\text{'}||$ v$\_$city$)$;

$$DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$State: $\text{'}||$ v$\_$state$)$;

$$DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}\text{'})$;$$

$$END LOOP;

$$END IF;

EXCEPTION

$$WHEN OTHERS THEN

$$DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$Error occurred: $\text{'}||$ SQLERRM$)$;

END;

$/$