sql loader - using SQL to update colums

From: Ken Chesak <datavector_at_hotmail.com>
Date: 12 Feb 2003 12:07:05 -0800
Message-ID: <3f2f39c4.0302121207.7ab5a32a@posting.google.com>

I am trying to use SQL to load the value of id_wage. This is the child table the parent table is already created with a value in id_wage. Based on case_no I need to update id_wage in the child table. Oracle 8.1.7

Thanks

Control File

LOAD DATA
INFILE 'wage_client.dat'
INTO TABLE w_wage_client
APPEND
(

        id_wage constant "select id_wage from w_wage_case
                          where case_no = :case_no",
        cd_source constant "IWAGE",
        case_no position (5-13))

Record 1: Rejected - Error on table W_WAGE_CLIENT, column ID_WAGE. ORA-01722: invalid number Received on Wed Feb 12 2003 - 14:07:05 CST