Thursday, January 22, 2009

SQL Loader in Oracle Applications(Draft)

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
)
at

5 comments:

  1. Anil KuppaApril 23, 2009 at 3:40 AM

    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.

    ReplyDelete
  2. sap pp tablesNovember 1, 2011 at 8:07 AM

    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.

    ReplyDelete
  3. UnknownApril 29, 2014 at 12:43 AM

    This comment has been removed by the author.

    ReplyDelete
  4. AnonymousAugust 3, 2016 at 9:11 PM

    This comment has been removed by the author.

    ReplyDelete
  5. AnonymousSeptember 6, 2016 at 9:38 AM


    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.

    ReplyDelete