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

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Rajneesh.

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

Last updated: March 26, 2020 - 3:55 am UTC

Version: 19 c

Viewed 1000+ 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 Connor 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 Comment

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library