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.

Dear user!

Please have a look at this thread.

Need small help

In the last three posts I explain how to use a shellscript with AWK and SED to pass parameters to a controlfile.

Please feel free to post again if you have some questions regarding my explanatory notes.

Yours sincerely

Florian W.