SQL Loader in Oracle Applications…
Step1:create a Sqlloader file.(the ctl file)
Step2:Create a executable with Execution method type as SQLLOADER
Step3:move .ctl file to executable application top bin folder
For example for GL it is GL_TOP/bin
Step4.Create a program for the executable with paramertes like file name..
Step6:Attach the concurrent program to a request group and the run the program..
The one point that comes in mind how to acess the concurrent program parameters in sqlloader..it is using %1
LOAD DATA
INFILE '%1'
BADFILE '%1.bad'
DISCARDFILE '%1.dis'
TRUNCATE
INTO TABLE GL_DOW_TRANS
(
VOTE POSITION(01:16) INTEGER EXTERNAL,
AMOUNT POSITION(18:30) INTEGER EXTERNAL,
PERIOD POSITION(35:38) INTEGER EXTERNAL
)
Subscribe to:
Post Comments (Atom)
5 comments:
Hi Murthy,
If we have to pass more than one parameter then we would have to concatenate it and then pass it. Instead of that we can call a concurrent program of host executable which would then call the sql loader script.
This post explain how to use SQL loader in Oracle applications. The simple method is given in terms source code for performing the same function. I really like the idea and code given is very easy. Thanks.
Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.
Post a Comment