 Parameters / Variables in SQL Loader Control File [message #411318] |
Fri, 03 July 2009 02:08  |
Mauragon
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
example
input data
123456,John,Smith
654321,Jane,Doe
loaded data
123456,John,Smith,03-JUL-2009,USER13
654321,Jane,Doe,03-JUL-2009,USER13
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
