Re: sql loader - using SQL to update colums

On 12 Feb 2003 12:07:05 -0800, datavector_at_hotmail.com (Ken Chesak) wrote:

>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

IIRC a sql statement doesn't constitute valid constant (please look that up in your manual) and you'll need to use triggers

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Feb 12 2003 - 14:47:51 CST