Database Utilities (MOSC)

MOSC Banner

Sql*Loader not liking FILLER

edited Jan 10, 2011 3:38AM in Database Utilities (MOSC) 3 commentsAnswered
 Hi,

     I am trying to load 2 separate tables with the following in my .ctl file:

LOAD DATA APPEND INTO TABLE rand_ap_odepot_headers WHEN tab = 'A' (tab FILLER position(1) CHAR,  invoice_id "rand_ap_odepot_headers_s.nextval",  summary_bill_nbr,  bill_from_date "to_date(:bill_from_date, 'MM/DD/YYYY')",  bill_to_date "to_date(:bill_to_date, 'MM/DD/YYYY')") INTO TABLE rand_ap_odepot_lines WHEN tab = 'B' (tab FILLER position(1) CHAR, invoice_id "rand_ap_odepot_headers_s.curval", line_nbr RECNUM, invoice_nbr FILLER, original_order FILLER, contact_name FILLER, ship_to, po_nbr,

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