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
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.
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.

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


Current Time: Fri Dec 09 05:48:04 CST 2016

Total time taken to generate the page: 0.05389 seconds