Created post webservice in Autonomous data base.
Created REST Data Source using above service in apex.oracle.com.
Calling data source from apex.oracle.com from PLSQL.
declare
l_params apex_exec.t_parameters;
lv_response VARCHAR2(4000);
begin
apex_exec.add_parameter( l_params, 'ENAME', 'TTSTATSTATSA' );
apex_exec.execute_rest_source(
p_static_id => 'POST_DATA',
p_operation => 'POST',
p_parameters => l_params );
lv_response := apex_exec.get_parameter_clob(l_params,'RESPONSE');
dbms_output.put_line('lv_response'||lv_response);
end;
Getting below error:
Error at line 5/38: ORA-20987: APEX - REST Data Source not found. - Contact your application administrator. ORA-06512: at "APEX_220200.WWV_FLOW_EXEC_API", line 1706 ORA-06512: at "APEX_220200.WWV_FLOW_ERROR", line 1074 ORA-06512: at "APEX_220200.WWV_FLOW_ERROR", line 1522 ORA-06512: at "APEX_220200.WWV_FLOW_EXEC_WEB_SRC", line 155 ORA-06512: at "APEX_220200.WWV_FLOW_EXEC_API", line 1684 ORA-06512: at "APEX_220200.WWV_FLOW_EXEC_API", line 1719 ORA-06512: at line 7 ORA-06512: at "SYS.DBMS_SQL", line 1721 3. lv_response VARCHAR2(4000); 4. begin 5. apex_exec.add_parameter( l_params, 'ENAME', 'TTSTATSTATSA' ); 6. 7. apex_exec.execute_rest_source(
pls help me.