Database Utilities (MOSC)

MOSC Banner

Problem with SQLLDR (ORA-01008: not all variables bound)

edited Feb 5, 2016 4:04AM in Database Utilities (MOSC) 1 commentAnswered

Created Control and Data files for SQL Loader. When I tried to load data using the control and data files from my desktop (Command Prompt using SQLLDR utility), data loaded without any issue. Then I created a concurrent program and copied control and data files to required locations and launched the program.Data is not loaded into table and log file shows below error.

ORA-01008: not all variables bound

Control File:

=========

OPTIONS (SKIP = 1)

LOAD DATA

INFILE '$FILE'

APPEND

INTO TABLE XXLLNW_LIOS_DL_T

FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'

TRAILING NULLCOLS

(

"SD_SNO"              FILLER,

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