RE: Trailing nullcols and external tables

  • From: "Shreeni" <shreeni@xxxxxxxxxxxxx>
  • To: <chris_stephens@xxxxxxxxxxxx>, "'ORACLE-L'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 27 Sep 2006 15:36:12 -0500

Is'nt the syntax " MISSING FIELD VALUES ARE NULL " ?
 
Thanks and have a good day.
 
Shreeni
(630) 401-2887 (Mobile)
(630) 837-1730 (Home)

 

  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Stephens, Chris
Sent: Wednesday, September 27, 2006 3:07 PM
To: ORACLE-L
Subject: Trailing nullcols and external tables


I've checked the sql reference and messed with the syntax but I don't seem
to be able to get trailing nullcols to work in defining an external table.
 
...is that not an option?
 
the create statement succeeds without error but when i select from the table
i get:
 
SQL> select count(*) from data2;
select count(*) from data2
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "identifier": expecting one of: "column,
enclosed, exit, (, ltrim, lrtrim, ldrtrim, missing, notrim, optionally,
rtrim,
reject"
KUP-01008: the bad identifier was: trailing
KUP-01007: at line 9 column 4
ORA-06512: at "SYS.ORACLE_LOADER", line 19
 
 
am i missing something?
 
CREATE TABLE "CMAP_WH"."DATA2"
   ( "GEOGRAPHY" VARCHAR2(255 BYTE),
 "COMMODITY" VARCHAR2(255 BYTE),
 "TIME_PERIOD" NUMBER(*,0),
 "MEASURE_NAME" VARCHAR2(255 BYTE),
 "MEASURE_VALUE" NUMBER,
 "UNIT" VARCHAR2(255 BYTE),
 "PARTNER_GEOGRAPHY" VARCHAR2(255 BYTE)
   )
   ORGANIZATION EXTERNAL
    ( TYPE ORACLE_LOADER
      DEFAULT DIRECTORY "LOC"
      ACCESS PARAMETERS
      ( RECORDS DELIMITED BY NEWLINE
    CHARACTERSET WE8MSWIN1252
    STRING SIZES ARE IN BYTES
    NOBADFILE
    NODISCARDFILE
    NOLOGFILE
    FIELDS
      TERMINATED BY ','
   trailing nullcols
       (
        "GEOGRAPHY" CHAR,
        "COMMODITY" CHAR,
        "TIME_PERIOD" CHAR,
        "MEASURE_NAME" CHAR,
        "MEASURE_VALUE" CHAR,
        "UNIT" CHAR,
        "PARTNER_GEOGRAPHY" CHAR
      )
        )
      LOCATION
       ( 'd.CSV'
       )
    )
   REJECT LIMIT UNLIMITED
/
 

CONFIDENTIALITY NOTICE: 
This message is intended for the use of the individual or entity to which it
is addressed and may contain information that is privileged,
confidential and exempt from disclosure under applicable law. If the reader
of this message is not the intended recipient or the employee or agent
responsible for delivering this message to the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please notify us immediately by email reply. 

Other related posts: