6 Replies Latest reply: Feb 12, 2013 12:41 PM by JohnL RSS

    SP2-0552 while creating an external table

    JohnL
      I am receiving the following error when trying create an external table - SP2-0552: Bind variable "264" not declared.

      Here is the code that I am trying to execute in SQLPLUS:

      create table email_list_ext (
      email VARCHAR2(255 BYTE),
      e_ind VARCHAR2(1 BYTE),
      e_date VARCHAR2(8 BYTE)

      )
      ORGANIZATION EXTERNAL
      (
      TYPE ORACLE_LOADER
      DEFAULT DIRECTORY TEMP_DIR
      ACCESS PARAMETERS (
      RECORDS DELIMITED BY NEWLINE
      SKIP=1
      BADFILE TEMP_DIR:'email_bad_%p.bad '
      LOGFILE TEMP_DIR:'email log%p.log'
      FIELDS (
      email position(1:255) CHAR(255),
      e_ind position(256:256) CHAR(1),
      e_date position(257:264) CHAR(8)
      )
      )
      LOCATION ( email_list.dat' )
      )
      REJECT LIMIT 100;

      Edited by: JohnL on Jan 31, 2013 2:14 PM