In an IG, I select records (row selector) and save them in a text item; there are several records chosen. How can I process the said item (varchar2) in PL/SQL to insert the records in an oracle table?
Discy Latest Questions
In a modal page I have a button that triggers a DA, inside the DA I execute PL / SQL code and in a certain place depending on the value of a variable obtained I execute the following code to show an error: apex_error.add_error ( p_message => 'ANY ERROR', p_display_location => apex_error.c_inline_in_notification); This statement is executed with errors, in the debug and shows a call stack, is it a bug? What other alternative do I have to show an error from PL / SQL? I am using apex 20 0.59400 0.00000 - display_location: INLINE_IN_NOTIFICATION 4 0% 0.59400 0.00000 - is_internal_error: false 4 0% 0.59400 0.00100 - is_common_runtime_error: false 4 0% 0.59500 0.00000 - error_backtrace: ----- PL/SQL Call Stack ----- object line object handle number name 00007FFC1A883A18 1039 package body APEX_200100.WWV_FLOW_ERROR.INTERNAL_GET_ERROR 00007FFC1A883A18 1107 package body APEX_200100.WWV_FLOW_ERROR.INTERNAL_ADD_ERROR 00007FFC1A883A18 1160 package body APEX_200100.WWV_FLOW_ERROR.ADD_ERROR 00007FFC26FE46D0 54 package body APEX_200100.WWV_FLOW_ERROR_API.ADD_ERROR 00007FFC0583F300 28 anonymous block 00007FFC1A6D09B0 2120 package body SYS.DBMS_SYS_SQL.EXECUTE 00007FFC1A8C79C0 590 package body SYS.WWV_DBMS_SQL_APEX_200100.EXECUTE 00007FFC1AC467F0 ...
In Apex 20.1, when consuming services from an api it shows the error Ora-29273 http request failure So I try in sqldeveloper the following: Select apex_web_service.make_rest_request ( P_url => 'https://developers.decidir.com/api/v2/healthcheck', P_http_method => 'GET') from dual; And I get the same error. I have created ACL with connect, resolve privileges for my apex user That link does not have CA, since testing it from Arc, postman or any browser works fine Any ideas ?