How to get bne:import value in PLSQL code
Hi All,
I have custom integrator interface based on PL/SQL procedure TYPE.
Part of the PL/SQL package i validate the data and insert it into staging table if validation is successfully.
Problem i have is when i select Upload Parameter "Validate Before Upload" it validates the data and insert into staging table
once validation is successfully, i select "Automatically Submit Import" option and submit it. This process again validate it and insert another set of records into the staging table which is creating duplicate in staging table
How can i prevent this
Thanks,
Jay