I'm trying to use an On Demand process to refresh a pl/sql region. However, the function that we are running requires more than 10 parameters anywhere between between 30 and 40 to be exact. My javascipt code is as follows:
apex.server.process ("P7_UPDATE_EARNINGS_REPORT",
{ x01: $v('P100_ID'),
x02: $v('P100_CALC_VAL'),
x03: $v('P100_METHOD'),
......
...... this area has variables for x04 to x10
-.......
, p_arg_names: ['G_11','G_12','G_13', ..... all others in between ......'G_36','G_37','G_38' ]
, p_arg_values: [$v('P100_G11_ITEM'),$v('P100_G12_ITEM'),$v('P100_G13_ITEM), ..... ALL OTHERS IN BETWEEN....... ,$v('P'),$v('P100_G37_ITEM'), $v('P100_G38_ITEM'), ]
},
{dataType:"text", success: function(pData){ $("#HTML_TO_REFRESH").replaceWith(pData); }}
);
The plsql code in the On the demand process is using Apex_Application.G_X01 to G_X10 , followed by :G_11, :G_12 as the parameters for the function that returns the html.
The issue is that I'm getting an error stating Unable to find Application or Page Item G_11 when I run the code in a dynamic action.
Any ideas?
Also worth noting is that we cannot use a classic report because the function uses apex collections for temporary storage, which causes a "DML in query" error.
Thanks in Advance.