Database Utilities (MOSC)

MOSC Banner

Sql loader - 350 FILLER not found error

edited Jun 13, 2011 11:57PM in Database Utilities (MOSC) 2 commentsAnswered
We have recently upgraded our database version to 11 from version 10.

One of the custom SQL loader programs is giving the following error after the upgrade.

The control file of the program is :

 

--             The field names from the datafile are shown as comments with their
--             sequence number for easier recognition.

OPTIONS ( ERRORS=999999 )
LOAD DATA
APPEND
INTO TABLE ap_expense_feed_lines_all
--WHEN CARD_CODE_VALUE <> 'IDD'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
c1             FILLER      CHAR,                      -- 1.  Record Type Indicator
ATTRIBUTE12                CHAR,                      -- 2.  Plan Number
CARD_NUMBER                CHAR
              "substr( LPAD(:CARD_NUMBER,16,'0'), 1, 4)  ||' '||

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