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.

Report message to a moderator

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: 68663
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

Report message to a moderator

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: 10707
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

Report message to a moderator

Previous Topic: NEWBIE: First time using SQL*Loader, plz help
Next Topic: How to estimate the size of export dump fille size?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jun 18 08:31:21 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.