Hi,
I am trying to use DataLoader API from SqlDeveloper as below:
declare
l_res apex_220100.wwv_flow_data_loading_api.t_data_load_result;
l_workspace_id number;
l_blob blob := <MY-BLOB>;
begin
l_workspace_id := apex_util.find_security_group_id (p_workspace => '<MY-WORKSPACE>');
apex_util.set_security_group_id (p_security_group_id => l_workspace_id);
l_res := apex_220100.wwv_flow_data_loading_api.load_data(p_application_id => 100, p_static_id => 'DJOGA_UPLOAD_TEST', p_data_to_load => l_blob);
end;
But I keep getting next error:
Error report -
ORA-00936: missing expression
ORA-06512: at "APEX_220100.WWV_FLOW_DATA_LOADING", line 1048
ORA-06512: at "APEX_220100.WWV_FLOW_EXEC", line 920
ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 993
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220100", line 847
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1703
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220100", line 833
ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 1903
ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 1877
ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 971
ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 1018
ORA-06512: at "APEX_220100.WWV_FLOW_EXEC_LOCAL", line 248
ORA-06512: at "APEX_220100.WWV_FLOW_EXEC_LOCAL", line 1382
ORA-06512: at "APEX_220100.WWV_FLOW_EXEC", line 911
ORA-06512: at "APEX_220100.WWV_FLOW_DATA_LOADING", line 896
ORA-06512: at "APEX_220100.WWV_FLOW_DATA_LOADING", line 1081
ORA-06512: at "APEX_220100.WWV_FLOW_DATA_LOADING_API", line 53
ORA-06512: at line 8
00936. 00000 - "missing expression"
*Cause:
*Action:
Can somebody help?