How can custom error messages from a package be returned to the WEBADI excel from Importer? I am wor
I need to return custom error messages from a package to the WEBADI excel from the Importer. I have defined the following: Can anyone please help?
Interface contains following columns : P_LINE_NO and other parameters.
I have defined an importer. Importer Type : PL/SQL API. I gave the LINE_NO as a parameter in the package.
This LINE_NO works as the run id, that is same for all the records in a particular RUN
I have defined the following:
1. Group Definition : Added P_LINE_NO, this is the parameter in the procedure used for the Importer package. The line no as defined earlier, works as a RUN ID for a particular run