Skip to Main Content
  • Questions
  • Submitting PL/SQL procedure execution request via REST

Breadcrumb

Dev Live Dev Intro

This month we are celebrating Developers at AskTOM. We welcome Developers of all levels of experience to join us at our FREE Developer Live events coming in August. Just click on the left to register today! If you are brand new to Database Technology, then we also have got you covered. Just click on the right for your comprehensive FREE training program to kick start your Oracle Database Development journey!

Question and Answer

Connor McDonald

Thanks for the question, Rajneesh.

Asked: March 25, 2020 - 4:37 am UTC

Answered by: Connor McDonald - Last updated: March 26, 2020 - 3:55 am UTC

Category: Database Development - Version: 19 c

Viewed 100+ times

You Asked

I need to click a URL on GUI page. Once clicked, respective PL/SQL procedure execution request should be submitted to respective database in form of query API request- REST API. Once procedure is executed in database, status message (success or failed with error message) should be returned in JSON format and should be transformed into appropriate format before getting displayed to GUI form (same GUI form which was used to submit the execution request).

Do I need to follow APEX way or ORDS will have provision to implement it?

Thanks,
Rajneesh

and we said...

ORDS can be configured to run a PL/SQL routine via a REST call.

Example of that here on Jeff's blog

https://www.thatjeffsmith.com/archive/2019/03/calling-a-pl-sql-function-via-ords/