OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » SQL Loader data file path for GL Interface

Home » Applications » Oracle Fusion Apps & E-Business Suite » SQL Loader data file path for GL Interface

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Loader data file path for GL Interface [message #116585]

Wed, 20 April 2005 14:16

oracle_user
Messages: 4
Registered: April 2005
Location: US

Junior Member

Hi Guys,

I am doing a GL Interface. I am using SQL* Loader to load data into staging tables. Now my question is, How can i give the path name dynamically for my data file through Apps instead of specifying it in the control file.

for ex..
generally we do it
LOAD DATA
INFILE 'path\file'
...

I some how want a variable in which i can pass the path of the data file, so that i can pass this through Apps.

Any ideas???

Thanks in advance

[Updated on: Wed, 20 April 2005 14:47]

Report message to a moderator