title: create/declare a sequence in a stored procedure in oracle
body: <p>I have a table non_employee with emp_no as the primary key and a package with a procedure to insert in to this table.</p>
  
  <p>I need to be able to autoincrement the emp_no when the procedure is run. I tried creating a sequence within the procedure like this, but getting errors. please see below and advice.</p>
  
  <pre><code>CREATE OR REPLACE PACKAGE BODY WFDDEV."ERD" IS
  
  create SEQUENCE @seq_emp_nmbr;
  
  PROCEDURE INS_NON_EMPLOYEES
  (
  in_DATE_ADDED        DATE,  
  in_EMPLOYEE_NAME     VARCHAR2,
  in_DEPT_ID           VARCHAR2,
  in_SUB_DEPARTMENT    VARCHAR2,
  in_LOCATION          VARCHAR2,
  in_WORK_TEL_NO       VARCHAR2,
  in_TOUR              VARCHAR2,
  in_REST_DAYS         VARCHAR2,
  in_HOME_ADDRESS      VARCHAR2,
  in_CITY              VARCHAR2,
  in_STATE             VARCHAR2,
  in_ZIP               VARCHAR2,
  in_HOME_TEL_NO       VARCHAR2,
  in_GENDER            VARCHAR2,
  in_RACE              VARCHAR2,
  in_DATE_OF_BIRTH     DATE,
  in_AGE               VARCHAR2,
  in_HIRE_DATE         DATE,
  in_UNION_AFFILIATION VARCHAR2,
  in_TITLE             VARCHAR2,
  in_NON_EE_INDICATOR  VARCHAR2
  ) IS
  BEGIN
  
  
  
  INSERT INTO WFDDEV.NON_EMPLOYEES
    (
    EMP_NO,
    DATE_ADDED,
    EMPLOYEE_NAME,
    DEPT_ID,
    SUB_DEPARTMENT,
    LOCATION,
    WORK_TEL_NO,
    TOUR,
    REST_DAYS,
    HOME_ADDRESS,
    CITY,
    STATE,
    ZIP,
    HOME_TEL_NO,
    GENDER,
    RACE,
    DATE_OF_BIRTH,
    AGE,
    HIRE_DATE,
    UNION_AFFILIATION,
    TITLE,
    NON_EE_INDICATOR
    )
  VALUES
    (
   emp_no.NEXTVAL,
    in_DATE_ADDED,
    in_EMPLOYEE_NAME,
    in_DEPT_ID,
    in_SUB_DEPARTMENT,
    in_LOCATION,
    in_WORK_TEL_NO,
    in_TOUR,
    in_REST_DAYS,
    in_HOME_ADDRESS,
    in_CITY,
    in_STATE,
    in_ZIP,
    in_HOME_TEL_NO,
    in_GENDER,
    in_RACE,
    in_DATE_OF_BIRTH,
    in_AGE,
    in_HIRE_DATE,
    in_UNION_AFFILIATION,
    in_TITLE,
    in_NON_EE_INDICATOR
    );
  END;
  </code></pre>
  
  <p>Im getting PLS-00103: Encountered the symbol "CREATE" when expecting one of the following:</p>
  
  <p>begin end function pragma procedure subtype type
      </p>
  
  <p>error with this...</p>