Passing parameters to sqlldr control file

What is the problem with creating a new control file, and then deleting it again immediately after the load? Show 1 more comment. Active Oldest Votes. Community Bot 1 1 1 silver badge. Add a comment. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.

Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Tue, 14 January Quote: Sub. Once again why don't you post it? FindAndReplace Report message to a moderator. Wed, 24 October Hi Team, kindly let me know how to pass direct values from. CTL file Report message to a moderator.

Use sqlldr parameters see Barbara's post above or dynamically create the CTL file see example. EdStevens Messages: Registered: September So you are able to create the control file on the fly and use it. So what's the problem now? Newsletter Topics Select minimum 1 topic. Big Data. Mirza Haris Beg October 13, 0 Comments.

So, please tell me how to declare a parameter in. Anonymous Posted October 13, 0 Comments. Sivaramprasad Vennelakanti Posted October 13, 0 Comments. Hello Sivaramprasad, Will you please forward me the hole coding of. Sivaramprasad Vennelakanti Posted October 14, 0 Comments.

Hello Mirza, Please find attached ctl and prog files. You may modify to suite your requirements. Thanks, Prasad. Hello Sivaramprasad, There is no attachment in your reply, so tell me from where I get those files. Sivaramprasad Vennelakanti Posted October 15, 0 Comments. Hello Mirza, I did attach the files. Register or Login.