Re: SQL Loader - How to load userid without hardcoding

--Boundary-8666788-0-0

Is this on a UNIX box? If so, I would think you could have a global variable where the user value should go and stick in an echo/read combination in front of the sqlldr command in your script file.

Tim Sawmiller
tsawmill_at_us.oracle.com
"The opinions expressed here are my own and not necessarily those of the Oracle Corporation".

--Boundary-8666788-0-0
Content-Type: message/rfc822

Date: 28 Feb 96 09:30:00
From:"CHANCL " <CHANCL_at_AM.NIE.AC.SG>
To: Multiple,recipients,of,list,ORACLE-L,ORACLE-L_at_CCVM.SUNYSB.EDU Subject: Re: SQL Loader - How to load userid without hardcoding Reply-to: ORACLE-L_at_CCVM.SUNYSB.EDU
X-Orcl-Application: Sender: "ORACLE database mailing list."  <ORACLE-L_at_CCVM.SUNYSB.EDU>
X-To: ORACLE-L_at_ccvm.sunysb.edu
X-Orcl-Application: In-Reply-To: <01I1QPX7OXB2001XDV*@mr.nie.ac.sg>

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

--Boundary-8666788-0-0-- Received on Wed Feb 28 1996 - 09:16:49 CST