SQL Language (MOSC)

MOSC Banner

Oracle External Table Error KUP-04021: field formatting error for field and KUP-04035: beginning enc

edited Jul 9, 2013 10:18AM in SQL Language (MOSC) 4 commentsAnswered
Hi,

  I have Oracle 11gR2 64bit running on RHEL 2.6.

 The format of the file seems correct to me and I don't understand why I am getting the error.  Any thoughts pls..

  I am trying to create an external table "test" on file, test.xml:

  <test><keydef><keyid>1</keyid><status>ACTIVE</status></keydef></test>

Here is my table test definition:

   CREATE TABLE test
   ( KEYID NUMBER(10,0),
        STATUS VARCHAR2(20 CHAR)
  )
   ORGANIZATION EXTERNAL
    ( TYPE ORACLE_LOADER
      DEFAULT DIRECTORY "SECURITY"
      ACCESS PARAMETERS
      ( RECORDS DELIMITED BY "</keydef>"
  badfile security:'test.bad'
    logfile security:'test.log'
    discardfile security:'test.dsc'
  FIELDS
  MISSING FIELD VALUES ARE NULL
  REJECT ROWS WITH ALL NULL FIELDS

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center