Hi Friends,
I got a requirement in which I have to load data into a staging data using SQL*Loader then validate the data and load the data into the target table.
I created a package with 2 procedures;1 for validating data in the staging table and another for loading data into the target table.And the target table is the Oracle apps Interface table.
But I also want to create a procedure to load data into staging table(SQL*Loader code).
I will run the package by creating a concurrent program in Oracle Applications.
Could anyone please suggest how can I include the SQL*Loader syntax in the procedure for loading the excel file into the staging table.
Oracle version 11g.
Below are the steps I need to follow:
Using SQL*Loader-->Source excel file --- load data into staging table
Procedure --> validate data on staging table
Procedure--> load data into target table.
Regards,
KVR