2 Replies Latest reply: Oct 29, 2012 1:53 PM by 971260 RSS

    Column not allowed here error

    971040
      Hi all,
      i'm newbie and i'm trying to follow the Oracle database 11g xe tutorials.. I have copyed the code for creating a Procedure
      but it's dosent works.. it tells me that "column not allowd here" on ADD_EVALUATION.total_score

      CREATE OR REPLACE PROCEDURE ADD_EVALUATIONS
      (
      EVALUATION_ID IN NUMBER
      , EMPLOYEE_ID IN NUMBER
      , EVALUATION_DATE IN DATE
      , JOB_ID IN VARCHAR2
      , MANAGER_ID IN NUMBER
      , DEPARTMENT_ID IN NUMBER
      , TOTAL_SCORE IN NUMBER
      ) AS
      BEGIN
      INSERT INTO EVALUATIONS (
      evaluation_id,
      employee_id,
      evaluation_date,
      job_id,
      manager_id,
      department_id,
      total_score
      )
      VALUES (
      ADD_EVALUATION.evaluation_id,
      ADD_EVALUATION.employee_id,
      ADD_EVALUATION.evaluation_date,
      ADD_EVALUATION.job_id,
      ADD_EVALUATION.manager_id,
      ADD_EVALUATION.department_id,
      ADD_EVALUATION.total_score
      );
      END ADD_EVALUATIONS;

      I just copy the [Official Tutorial|http://isu.ifmo.ru/docs/doc112/appdev.112/e10766/tdddg_subprograms.htm#BABDHFAC]

      as it is.. any body can help me?
      thanks!