Home -> Usenet -> comp.databases.oracle -> SQL*Loader - How do I use a field from a source file that has no column in the table?

SQL*Loader - How do I use a field from a source file that has no column in the table?

From: Don <dchamber_at_mindspring.com>
Date: 5 Sep 2001 19:01:02 -0500
Message-ID: <ceedpto860e00bt3sv3613hr043mqoi2f6_at_4ax.com> 






I'm using SQL*Loader to load a table and I have the following
situation.


The table is as follows:




pk_id  Primary Key


fk_id   Foreign Key


code   VARCHAR2(10)




And the source file is as follows:


val1,val2,theCode



The value for pk_id is entered with a trigger but fk_id is a foreign
key that I must lookup in another table.  I have a stored function
that will look up this value given val1 and val2 from the source file.
How do I do this?



I have tried the following in the control file:
val1    FILLER CHARACTER,


fk_id   getID(:val1,fk_id),


code   CHARACTER



But this fails because val1 is not bound.  Is i remove the : from val1
I get an error that the column does not exists.  I have a similar load
in which the fk_id uses a function that only takes 1 argument.  This
works fine.



How do I use a field from the source file that has no corresponding
column in the table.



Thanks,


   Don


dchamber_at_mindspring.com
Received on Thu Sep 06 2001 - 02:01:02 CEST












Original text of this message