4 Replies Latest reply: Feb 7, 2013 5:44 AM by 987149 RSS

    Error in log file - Row wrong informed

    987149
      Hello. I have an error about the log file. Depending of the READ SIZE parameter, the number of the rows informed aren't correct. For example, if I set READSIZE parameter to 10000 and I try load an file with errors, the line informed in the log is 29 but it should be 28, the line informed in the log is 58 but it should be 59 and so.

      Any help?
      Thanks!
        • 1. Re: Error in log file - Row wrong informed
          BluShadow
          Please post all relevant information about your external table with some example data that demonstrates your problem

          Read: {message:id=9360002}
          • 2. Re: Error in log file - Row wrong informed
            BluShadow
            984146 wrote:
            Hello. I have an error about the log file. Depending of the READ SIZE parameter, the number of the rows informed aren't correct. For example, if I set READSIZE parameter to 10000 and I try load an file with errors, the line informed in the log is 29 but it should be 28, the line informed in the log is 58 but it should be 59 and so.

            Any help?
            Thanks!
            Just a thought.... does your external table definition have a SKIP 1 statement in it? It could be that you are skipping a header row and the log is reporting the row of 'data' after that.
            • 3. Re: Error in log file - Row wrong informed
              987149
              file:

              example de row:

              AAAAAAAAAAAAAA#AAAAAAAAAA#AAAAAAAAAAAAA#AAAAAAAAAA#AAA#AAAAAAAA#AAAAAAAAAAAAAAAAAAAAAAAAAAAA#AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA#AAA#AAAAAAAAAA#AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA#AAAAAAAAAAAAAAAAAAAAAAAAA#AAAAAAAA#AAAA#AAAAA#AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA

              log:

              LOG file opened at 01/25/13 11:02:49

              Field Definitions for table TMP_401143
              Record format DELIMITED BY NEWLINE
              Data in file has same endianness as the platform
              Reject rows with all null fields

              Fields in Data Source:

              UPLD_AUX_FLD_01 CHAR (255)
              Terminated by "#"
              Trim whitespace from left and right
              UPLD_DATADHSTART CHAR (255)
              Terminated by "#"
              Trim whitespace from left and right
              UPLD_INT_VL CHAR (255)
              Terminated by "#"
              Trim whitespace same as SQL Loader
              PREMAMNTRCV CHAR (255)
              Terminated by "#"
              Trim whitespace same as SQL Loader
              UPLD_AUX_FLD_15 CHAR (255)
              Terminated by "#"
              Trim whitespace from left and right
              UPLD_AUX_FLD_16 CHAR (255)
              Terminated by "#"
              Trim whitespace from left and right
              UPLD_NME CHAR (255)
              Terminated by "#"
              Trim whitespace from left and right
              UPLD_AUX_FLD_14 CHAR (255)
              Terminated by "#"
              Trim whitespace from left and right
              UPLD_AUX_FLD_04 CHAR (255)
              Terminated by "#"
              Trim whitespace from left and right
              UPLD_BTH_DT CHAR (255)
              Terminated by "#"
              Trim whitespace from left and right
              UPLD_ADR CHAR (255)
              Terminated by "#"
              Trim whitespace from left and right
              UPLD_ADR2 CHAR (255)
              Terminated by "#"
              Trim whitespace from left and right
              UPLD_CTY CHAR (255)
              Terminated by "#"
              Trim whitespace from left and right
              UPLD_ADR_CMP CHAR (255)
              Terminated by "#"
              Trim whitespace from left and right
              UPLD_ZIP CHAR (255)
              Terminated by "#"
              Trim whitespace from left and right
              UPLD_PHO_CMM_NBR CHAR (255)
              Terminated by "#"
              Trim whitespace from left and right
              CLIENTBANKCODE CHAR (255)
              Terminated by "#"
              Trim whitespace from left and right
              CLIENTAGENCYCODE CHAR (255)
              Terminated by "#"
              Trim whitespace from left and right
              UPLD_CREDITCARNUM CHAR (255)
              Terminated by "#"
              Trim whitespace from left and right
              CREDITCARDTYPE CHAR (255)
              Terminated by "#"
              Trim whitespace from left and right
              CLIENTTYPE CHAR (255)
              Terminated by "#"
              Trim whitespace from left and right
              error processing column PREMAMNTRCV in row 1 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 2 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 3 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 4 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 5 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 6 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 7 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 8 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 9 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 10 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 11 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 12 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 13 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 14 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 15 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 16 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 17 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 18 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 19 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 20 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 21 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 22 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 23 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 24 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 25 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 26 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 27 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 28 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 30 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 31 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 32 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 33 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 34 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 35 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 36 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 37 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 38 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 39 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 40 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 41 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 42 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 43 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 44 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 45 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 46 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 47 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 48 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 49 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 50 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 51 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 52 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 53 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 54 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 55 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 56 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 57 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 59 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 60 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 61 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 62 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 63 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 64 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 65 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 66 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 67 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 68 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 69 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 70 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 71 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 72 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 73 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 74 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 75 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 76 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 77 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 78 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 79 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 80 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 81 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 82 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 83 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 84 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 85 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 86 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 88 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 89 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 90 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 91 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 92 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 93 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 94 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 95 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 96 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 97 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 98 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 99 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 100 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 101 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 102 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 103 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 104 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 105 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 106 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 107 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 108 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 109 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 110 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 111 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 112 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 113 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 114 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 115 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 117 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 118 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 119 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 120 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 121 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 122 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 123 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 124 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 125 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 126 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 127 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 128 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 129 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 130 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 131 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 132 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 133 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 134 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 135 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 136 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 137 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 138 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 139 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 140 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 141 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 142 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 143 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 144 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 145 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 147 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 148 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 149 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 150 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 151 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 152 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 153 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 154 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 155 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 156 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 157 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 158 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 159 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 160 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 161 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 162 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 163 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 164 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 165 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 166 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 167 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 168 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 169 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 170 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 171 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 172 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 173 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 174 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 176 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 177 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 178 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 179 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 180 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 181 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 182 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 183 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 184 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 185 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number
              error processing column PREMAMNTRCV in row 186 for datafile c:\\INBOX1\prueba.PRO
              ORA-01722: invalid number


              script:

              create table SCHE.Tmp_401135( UPLD_AUX_FLD_01 VARCHAR2 (50), UPLD_DATADHSTART VARCHAR2(20), UPLD_INT_VL VARCHAR2 (182), PREMAMNTRCV NUMBER (28,2), UPLD_AUX_FLD_15 VARCHAR2 (50), UPLD_AUX_FLD_16 VARCHAR2 (50), UPLD_NME VARCHAR2 (100), UPLD_AUX_FLD_14 VARCHAR2 (180), UPLD_AUX_FLD_04 VARCHAR2 (50), UPLD_BTH_DT VARCHAR2(20), UPLD_ADR VARCHAR2 (180), UPLD_ADR2 VARCHAR2 (180), UPLD_CTY VARCHAR2 (50), UPLD_ADR_CMP VARCHAR2 (40), UPLD_ZIP CHAR (15), UPLD_PHO_CMM_NBR VARCHAR2 (10), CLIENTBANKCODE VARCHAR2 (25), CLIENTAGENCYCODE VARCHAR2 (20), UPLD_CREDITCARNUM VARCHAR2 (25), CREDITCARDTYPE VARCHAR2 (15), CLIENTTYPE VARCHAR2 (20))
              organization external (type oracle_loader default directory INBOX1 access parameters (records delimited by newline
              badfile Loadfile1:'prueba.PRO.bad'
              logfile Loadfile1:'prueba.PRO.log'
              discardfile Loadfile1:'prueba.PRO.dsc'
              READSIZE 10000 fields terminated by '#' missing field values are null REJECT ROWS WITH ALL NULL
              FIELDS (UPLD_AUX_FLD_01 CHAR LRTRIM, UPLD_DATADHSTART CHAR LRTRIM, UPLD_INT_VL , PREMAMNTRCV , UPLD_AUX_FLD_15 CHAR LRTRIM, UPLD_AUX_FLD_16 CHAR LRTRIM, UPLD_NME CHAR LRTRIM, UPLD_AUX_FLD_14 CHAR LRTRIM, UPLD_AUX_FLD_04 CHAR LRTRIM, UPLD_BTH_DT CHAR LRTRIM, UPLD_ADR CHAR LRTRIM, UPLD_ADR2 CHAR LRTRIM, UPLD_CTY CHAR LRTRIM, UPLD_ADR_CMP CHAR LRTRIM, UPLD_ZIP CHAR LRTRIM, UPLD_PHO_CMM_NBR CHAR LRTRIM, CLIENTBANKCODE CHAR LRTRIM, CLIENTAGENCYCODE CHAR LRTRIM, UPLD_CREDITCARNUM CHAR LRTRIM, CREDITCARDTYPE CHAR LRTRIM, CLIENTTYPE CHAR LRTRIM) )
              location ('prueba.PRO')) reject limit 250
              • 4. Re: Error in log file - Row wrong informed
                987149
                The error has relation with READSIZE parameter and FILESIZE. For example, if you set a READSIZE very small and you try to load an file of 1000000 registries, a lot the row informed are incorrect.