Passing parameters from concurrent program to SQL*plus mode script
Hi All,
I am trying to fetch parameter passed from concurrent program to my sql script.
I am trying to assign that value to one variable but it is not happening.
l_employee_number := '&&1';
FND_FILE.PUT_LINE(FND_FILE.LOG, 'Execution for employee number :=' || l_employee_number);
Output :
Execution for employee number :=&&1
Data type for parameter is CHAR and variable is VARCHAR.
I want to print exact employee number which is passed from application.
Details :
RDBMS : 11.2.0.2.0
Oracle Applications : 11.5.10.2
Thanks and Regards,
Piyush Ojha