Home » RDBMS Server » Server Utilities » Passing parameters to a .ctl file
Passing parameters to a .ctl file [message #234961] Thu, 03 May 2007 09:53 Go to next message
calsarau
Messages: 1
Registered: May 2007
Junior Member
I've got different files to load into a oracle database. And I want to load different values into a field depending on the file.
For instance, if i load the first file i want to load the value '1' for the field c_reg, and if i load the seconfd file i want to load the value '2' for the field c_reg, and so on.
To solve that problem i want to pass a parameter to a .ctl file to use a decode or a when topic. Is it possible to pass a parameter to a ctl file?.

Thanks in advance, Jordi.
Re: Passing parameters to a .ctl file [message #234979 is a reply to message #234961] Thu, 03 May 2007 10:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.
You have to modify the control from a shell script above.

Regards
Michel
Re: Passing parameters to a .ctl file [message #235106 is a reply to message #234961] Fri, 04 May 2007 01:41 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
As Michel already said,
you dynamically edit/create your control file.
Here is an example. filename is passed as input to controlfile.
http://www.orafaq.com/forum/m/35341/42800/?srch=controlfile+constant+sqlldr#msg_35341
Previous Topic: NEWBIE: First time using SQL*Loader, plz help
Next Topic: How to estimate the size of export dump fille size?
Goto Forum:
  


Current Time: Sat Dec 10 20:10:48 CST 2016

Total time taken to generate the page: 0.07075 seconds