Oracle快递包缺少右括号

Question

我在调用此包中的函数时遇到缺少右括号错误，您能帮我吗？

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;

Answer 1

您在第一个 EXECUTE 语句中拼错了“constraint”。

Answer 2

我没有 Oracle 数据库来测试这个。首先独立执行建表语句，看是否关心建表没有错误。那么你必须放弃一切。然后从过程中删除所有语句并进行测试。然后只添加一条语句并尝试。像这样尝试一次添加一个语句。您将看到哪一个给出了错误。你可能必须解决这个问题。