Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

apex.server.process with More than 10 Parameters

Edwin TAug 25 2016 — edited Aug 26 2016

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 23 2016
Added on Aug 25 2016
4 comments
3,128 views