I am using Apex 22.1.
My form has an editable interactive grid populated from a rest data source based on provided search parameters. I am running into errors when trying to save updates to the rows back to the rest data source.
First, I tried out-of-box Auto row processing (DML). but I get the following error:
"Current version of data in database has changed since user initiated update process."
I then changed the process to "Execute Code" and wrote the following code as per the APEX API documentation. However, this also gives the ORA-06550 error "PLS-00306: wrong number or types of arguments in call to 'EXECUTE_REST_SOURCE'".. The code that I wrote is as follows:
DECLARE
l_params apex_exec.t_parameters;
rest_response clob;
begin
case when :RQD_ACTION = 'U' then
begin
apex_exec.add_parameter(l_params,'ProjectId',:P30_PROJECTID);
apex_exec.add_parameter(l_params,'TaskUniqId',:TASKUNIQID);
apex_exec.add_parameter(l_params,'TASKSTARTDATE',:REQ_TASK_START_DATE);
apex_exec.add_parameter(l_params,'TASKENDDATE',:REQ_TASK_END_DATE);
apex_exec.add_parameter(l_params,'TASK_EFFORT_IN_HOURS',:REQ_EST_EFFORT);
apex_exec.execute_rest_source(
p_module_static_id => 'PROJECT_TASKS',
p_operation => 'PATCH',
p_url_pattern => '/:TaskUniqId',
p_parameters => l_params
);
rest_response := apex_exec.get_parameter_clob(l_params,'RESPONSE');
:P30_POST_RESPONSE := :P30_POST_RESPONSE || CHR(20) || 'Update Task:' ||REQ_TASK_NAME ||' action result:' ||rest_response;
end;
else
:P30_POST_RESPONSE := :P30_POST_RESPONSE || CHR(20) || 'Update Task:' ||REQ_TASK_NAME ||' no action **';
end case;
end;
Please help.