Re: sql*loader - load same sequence in 2 columns

Hi Paul,

    I got it to work for me on a test file, although I know getting something to work on test data on live data are 2 different things. One thing I had to do was add a Trailing Nullcols statement after the delimiter statement so you could try that. In the meantime as a workaround you could do this

create or replace trigger gtregion_insert before insert on gtregion
for each row
begin

    if :new.A_COUNTRY_ID is null then

        :new.A_COUNTRY_ID := :new.A_REGION_ID ;    end if;
end;

and then remove A_COUNTRY_ID from the control file

HTH Conan

paulbenton_at_my-deja.com wrote in message <8qt111$ut8$1_at_nnrp1.deja.com>...
>In article <kRjA5.3841$Bw1.2196_at_news.indigo.ie>,
> "Conan" <conan_at_(no-spam)as-if.com> wrote:
>> Hi Paul
>> try
>>
>> A_COUNTRY_ID Integer ":A_REGION_ID "
>>
>> HTH
>>
>> Conan
>>
>> Thanks Conan, but unfortunately I had already tried that and it does
>not work - lots of errors in log file.
>
>Any other suggestions? It seems like a simple thing to do but I can't
>see any way.
>
>Paul
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Thu Sep 28 2000 - 11:59:19 CEST