APEX

Good day,

This is my first post on the board but as PL/SQL is not my expertise, I thought my give you guys a shot after searching the forum, could not find a solution..

I have an On-Demand Application Process called "UPDATE_EMPLOYEE":

BEGIN
UPDATE OEHR_EMPLOYEES
SET APEX_APPLICATION.G_F01(2) = APEX_APPLICATION.G_F01(1)
WHERE employee_id = APEX_APPLICATION.G_F01(1);
COMMIT;
END;


I have a javascript function which calls the on-demand process:

function updateDB(oGrid_Event) {
var get = new htmldb_Get(null,$v('pFlowId'),'APPLICATION_PROCESS=UPDATE_EMPLOYEE',0);

get.addParam('F01', oGrid_Event.record.data.employee_id);
get.addParam('F01', oGrid_Event.field);
get.addParam('F01', oGrid_Event.value);
};


When I look into Firebug, the array is capturing the data perfectly, however, I believe the error lies in the PL/SQL as it is not updating.

I tried without using the F01 array and just passing id,field,value & using v('id') ... in the process but I'm not getting the update to work.

Any help is greatly appreciated.