Re: SQL Loader - How to load userid without hardcoding

Hi Dave & Sanjay !

Thanks 4 your replies regarding the above qn.

Dave Ans:
>> sqlloader username/password control=controlfile.ctl

Sanjay Ans:
>> ... thru forms4.5 use Get_Application_Property ...
>> Otherwise while running Sql loader it will ask for these parameters.

However, that's not what I am asking 4. Let me rephrase my qn again.

My table Table1 contains field :

1) userid varchar2(30)
2) Tablecounter number(4)
2) Field1 varchar2(12)

My data file contains only Field1 data from 1 to 12 position eg 123456789012
222222222222

My ctrl file,
LOAD DATA INTO TABLE TABLE1
( USERID USER(),
 TABLECOUNTER SEQUENCE(MAX,1),
 FIELD1 POSITION(01:12) CHAR) I am trying to load my data from data file into Table1 without hardcoding my userid in my control/data file by using function like user, user() etc. It always give me error.

Do I REALLY have to hardcode my username in my data/control file ? HELP ! TIA ChorLing
chancl_at_nievax.nie.ac.sg

PS. Please send your reply to chancl_at_nievax.nie.ac.sg Received on Wed Feb 28 1996 - 02:33:36 CST