title: Oracle express package missing right parenthesis
body: <p>I'm getting missing right parenthesis error while calling the function in this package , could you please help me ?</p>
  
  <pre><code>create or replace package body "GESTIONRH" is
  
  procedure CREATETABLES
  as
  begin
  
    EXECUTE IMMEDIATE 'CREATE TABLE jobs
    ( job_id         VARCHAR2(10)
    , job_title      VARCHAR2(35)
    , min_salary     NUMBER(6)
    , max_salary     NUMBER(6)
    , constrataint pk_jobs primary key (job_id) )  '; 
  
    EXECUTE IMMEDIATE 'Create table departments
    ( department_id    NUMBER(4)
    , department_name  VARCHAR2(30)
    , manager_id       NUMBER(6)
    , location_id      NUMBER(4)
    , constraint pk_dep primary key(department_id)  ) '; 
  
    EXECUTE IMMEDIATE 'CREATE TABLE employees
    ( employee_id    NUMBER(6)
    , first_name     VARCHAR2(20)
    , last_name      VARCHAR2(25)
    , email          VARCHAR2(25)
    , phone_number   VARCHAR2(20)
    , hire_date      DATE
    , job_id         VARCHAR2(10)
    , salary         NUMBER(8,2)
    , commission_pct NUMBER(2,2)
    , manager_id     NUMBER(6)
    , department_id  NUMBER(4)
    , CONSTRAINT pk_employee primary key (employee_id)      )';
  
    EXECUTE IMMEDIATE 'CREATE TABLE job_history
    ( employee_id   NUMBER(6)
    , start_date    DATE
    , end_date      DATE
    , job_id        VARCHAR2(10)
    , department_id NUMBER(4)
    , CONSTRAINT pk_job_history primary key (employee_id, start_date) )'; 
  
    EXECUTE IMMEDIATE 'CREATE TABLE dependents
    ( Id    NUMBER(6)
    , FirstName     VARCHAR2(20)
    , LastName      VARCHAR2(25)
    , Birthdate Date
    , Relation VARCHAR2(20)
    , Gender VARCHAR2(2)
    , RelativeId Number(6) 
    , CONSTRAINT pk_dependent primary key (Id))';         
  
  end CREATETABLES;
  
  end GESTIONRH;
  </code></pre>