Re: parameters are not passed to concurrent requests

Posted by anandmandilwar on
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/parameters-are-not-passed-to-concurrent-requests-tp5346p5359.html

Hi Erman
These parameters are directly passed onto the underlying executable (which in my case is PL/SQL Stored procedure).

Now coming to your question as how parameters in concurrent program are mapped to parameters in underlying procedure

Since the executable here is "PL/SQL Stored procedure" and once the executable is attached in front end, whatever parameter we define in the front end is mapped one to one with the procedure parameter

e.g. If in the front end
Program 1st parameter description is "Start Date" and parameter name is p_start_date, 2nd Parameter description is "End Date"  and parameter name is p_end_date and 3rd parameter description is 'Period Name (parameter name - p_period_name)  

Underlying procedure will have the argument as
p_start_date
p_end_date & p_period_name
In addition to that there will be 2 additional parameters in procedure (p_start_date & p_ret_code)

Hope this answered your query