SQL*Loader: Release 21.0.0.0.0 - Production on Tue May 24 10:01:59 2022
Version 21.3.0.0.0

Copyright (c) 1982, 2021, Oracle and/or its affiliates.  All rights reserved.

Control File:   J:\ORACLE_LOAD\INSERT_merrill.ctl
Data File:      H:\TESTING\TEST2.TXT
  Bad File:     J:\MERRILLOUTPUT\MERRILL.BAD
  Discard File: J:\MERRILLOUTPUT\MERRILL_DISCARD.TXT 
 (Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array:     250 rows, maximum of 1048576 bytes
Continuation:    none specified
Path used:      Conventional

Table MERRILL, loaded from every logical record.
Insert option in effect for this table: REPLACE

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
ACCOUNT_DATE                        FIRST     *   ?       DATE MM/DD/YYYY      
ACCOUNT_NUMBER                       NEXT     *   ?       CHARACTER            
ACCOUNT_NUMBER_OLD                   NEXT     *   ?       CHARACTER            
ACCOUNT_NAME                         NEXT     *   ?       CHARACTER            
ACCOUNT_REGISTRATION                 NEXT     *   ?       CHARACTER            
CASH_BALANCE                         NEXT     *   ?       CHARACTER            
MONEY_ACCOUNTS                       NEXT     *   ?       CHARACTER            
PRICED_INVESTMENTS                   NEXT     *   ?       CHARACTER            
MARGIN_BALANCE                       NEXT     *   ?       CHARACTER            
MARKET_VALUE                         NEXT     *   ?       CHARACTER            

Record 8: Rejected - Error on table MERRILL, column ACCOUNT_NUMBER.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 1: Rejected - Error on table MERRILL, column MARGIN_BALANCE.
ORA-01722: invalid number

Record 2: Rejected - Error on table MERRILL, column MARGIN_BALANCE.
ORA-01722: invalid number

Record 3: Rejected - Error on table MERRILL, column MARGIN_BALANCE.
ORA-01722: invalid number

Record 4: Rejected - Error on table MERRILL, column MARGIN_BALANCE.
ORA-01722: invalid number

Record 5: Rejected - Error on table MERRILL, column MARGIN_BALANCE.
ORA-01722: invalid number

Record 7: Rejected - Error on table MERRILL, column MARGIN_BALANCE.
ORA-01722: invalid number


Table MERRILL:
  1 Row successfully loaded.
  7 Rows not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.


Space allocated for bind array:                 645000 bytes(250 rows)
Read   buffer bytes: 1048576

Total logical records skipped:          0
Total logical records read:             8
Total logical records rejected:         7
Total logical records discarded:        0

Run began on Tue May 24 10:01:59 2022
Run ended on Tue May 24 10:02:05 2022

Elapsed time was:     00:00:05.54
CPU time was:         00:00:00.05