Is it better to use APEX_WEB_SERVICE to call other apis or PL/SQL Procedure in Oracle Apex.
Hello,
We are using Oracle Visual Builder Studio for front-end development and Oracle Apex for Backend API development.
The requirement is to store a file in the Apex DB from Oracle Visual Builder along with selected users json.
We created a package with a procedure to insert file along with users into Oracle Apex.
However a new suggestion to use APEX_WEB_SERVICE to call another api which has insert statements to insert file and user json.
Could you please let me know if APEX_WEB_SERVICE or PLSQL Procedure approach is better for the requirement mentioned when using VBS for front-end and Apex as Backend.