Home » RDBMS Server » Server Utilities » Parameters / Variables in SQL Loader Control File (Oracle Database 10g)
icon8.gif  Parameters / Variables in SQL Loader Control File [message #411318] Fri, 03 July 2009 02:08 Go to next message
Messages: 20
Registered: February 2007
Location: Philippines
Junior Member
Here's my problem, I have created SQL Loader control file (ctl) to load a file of employees. This loader program is registered in Oracle Applications. What I want is to pass a parameter derived from the profile like the user name of the one who executed the loader program and pass it to the loader program so that the user name info is included in the loading


input data

loaded data

the sysdate is easy because it can be defined in the column but what I really want to achieve is a parameter passed to the ctl file.

Thanks in advance.
Re: Parameters / Variables in SQL Loader Control File [message #411499 is a reply to message #411318] Sat, 04 July 2009 06:31 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Check whether this will help you or not.

Previous Topic: import issue
Next Topic: SQLLDR - look up on table to find column value
Goto Forum:

Current Time: Fri Oct 28 02:04:44 CDT 2016

Total time taken to generate the page: 0.10414 seconds