Please help me running this code, thank You.

Feature $3$: search for job posts. The input includes a keyword, job type $($full time or part time$),$ and a state. The procedure does the following:

$1)$ It finds all job posts that are active and the job title or job description has a substring that matches the input keyword, and the job post's state and job type match the input state and job type. The procedure prints out the matching job posts' job post id$,$ associated company name, job title, description, min and max pay, city and state.

$2)$ In case there are no matching job posts, print out $\text{'}$No job posts found'.

Hint: to match a substring in the procedure, use

where column$\_$name like $\text{'}\%\text{'}||$ input$\_$keyword $||\text{'}\%\text{'}$

create table job$\_$posts $($

job$\_$post$\_$id number primary key,

company$\_$name varchar$2(100),$

job$\_$title varchar$2(100),$

description varchar$2(500),$

min$\_$pay number,

max$\_$pay number,

city varchar$2(50),$

state varchar$2(50),$

job$\_$type varchar$2(20),$

status varchar$2(20)$

$)$;

insert into job$\_$posts VALUES $(1,$ 'ABC Company', 'Software Engineer', 'Seeking experienced software engineer', $60000,80000,$ 'Example City', $\text{'}$CA$\text{'},$ 'full time', 'active'$)$;

insert into job$\_$posts VALUES $(2,\text{'}$XYZ Corporation', 'Data Analyst', 'Looking for a skilled data analyst', $50000,70000,$ 'Another City', $\text{'}$NY$\text{'},$ 'part time', 'active'$)$;

insert into job$\_$posts VALUES $(3,\text{'}123$ Inc.$\text{'},$ 'Marketing Specialist', 'Join our marketing team', $45000,60000,$ 'Cityville', $\text{'}$CA$\text{'},$ 'full time', 'inactive'$)$;