Packages code in PL/SLQ

السلام عليكم ورحمه الله وبركاته

ممكن حد يقولى ايه الغلط فى الكود ده

CREATE OR REPLACE PACKAGE job_pkg2 IS
  PROCEDURE add_job(name VARCHAR2,ID VARCHAR2);
   PROCEDURE upd_job(name1 VARCHAR2,ID1 VARCHAR2);
    PROCEDURE del_job(name2 VARCHAR2);
END job_pkg2;
/
CREATE TABLE jjob AS SELECT * FROM jobs;
CREATE OR REPLACE PACKAGE BODY job_pkg2 IS
  FUNCTION get_job(ID VARCHAR2) RETURN VARCHAR2 IS
    job_name jjob.JOB_TITLE%type;
    ID jjob.job_id%TYPE;
  BEGIN

    SELECT JOB_TITLE INTO job_name
    FROM   jjob;
    WHERE job_id=ID;
    RETURN job_name;
END get_job;

  PROCEDURE add_job(name VARCHAR2,ID VARCHAR2) IS 
  name jjob.JOB_TITLE%type;
    ID jjob.job_id%TYPE;
  BEGIN
  INSERT INTO jjob( JOB_TITLE) 
  VALUES(name)
  END add_job;

PROCEDURE upd_job(name1 VARCHAR2,ID1 VARCHAR2) IS 
name1 jjob.JOB_TITLE%type;
ID1 jjob.job_id%TYPE;
BEGIN
  UPDATE  jjob   
 SET job_title=name1;
 WHERE job_id=ID1;
END upd_job;

 PROCEDURE del_job(name2 VARCHAR2(35)) IS 
 name2 jobs.JOB_TITLE%type;
 BEGIN
  DELETE FROM  jjob    
 WHERE job_title=name2;
END del_job ;
END job_pkg2;
/

Packages code in PL/SLQ

مواضيع مشابهة