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:

Doyensys

A technology service company that provides innovative solutions around the oracle platform With Laser focus on customer delight as the primary success parameter.