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

Breadcrumb

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/



Is this answer out of date? If it is, please let us know via a Review