Apex.server.process

This function
calls a PL/SQL on-demand process defined on page or application level.


It’s an wrapper of the jQuery.ajax function and supports all the setting the jQuery function provides but provides additional Application Express features.

  

Apex.server.process is an feature available in  Oracle APEX4.2
and above. This is an Asynchorous Process.



Format:apex.server.process( pAjaxIdentifier,
pData, pOptions )

pAjaxIdentifier  : Required                         


Use the value
returned by PL/SQL package
apex_plugin.get_ajax_identifier to identify
your plug-in.

pData  : Optional
you can set the scalar parameters x01 – x10 and the arrays
f01 – f20).

pOptions : Optional

Object which can optionally be used to set additional options
used by the AJAX


 
Step:1

Create On-demand process(Application Process).
 

Step:2
Create
Dynamic Actions using Execute Javascript code.
 
Call the
On-demand process in apex.server.process with parameters.
Eg:
apex.server.process(“t1”,{x01:p_item_value},
{dataType: “text”,
Success: function(pData){alert(pData)
$x(“f03_”+new1).value=pData}});
Application Name – t1

Parameter:
Scalar Parameter- x01:p_item_value
Application process return value will be assigned to pData.
pData is assigned to tabular form column value(“f03_”+new1).
 

Step:3

Change the values in tabular form and next field will
get displayed as dynamically.

Step:4 :  Output:

  • October 12, 2015 | 19 views