Is it better to use APEX_WEB_SERVICE to call other apis or PL/SQL Procedure in Oracle Apex. — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!