publish oracle plsql procedure via ORDS instead of EPG - Stack Overflow

A customer has a procedure that can be called via Embedded Procedure Gateway (EPG and orawsv) like this http://192.168.50.7:8080/scan/scan_menu?p_mi_id=104888 ("scan" is the DAD) and I can call the very same procedure via ORDS http://192.168.50.7:19090/ords/ww2b_scan/scan_menu?p_mi_id=104888

It was coded a long time ago but how was it done ? (DB is 12.1)

How can I publish a non-JSON, non-REST procedure that generates nice webpages (using htp, htf, owa) in ORDS? No schema and no module is ORDS enabled, for the life of me I can't say how it's done.

A customer has a procedure that can be called via Embedded Procedure Gateway (EPG and orawsv) like this http://192.168.50.7:8080/scan/scan_menu?p_mi_id=104888 ("scan" is the DAD) and I can call the very same procedure via ORDS http://192.168.50.7:19090/ords/ww2b_scan/scan_menu?p_mi_id=104888

It was coded a long time ago but how was it done ? (DB is 12.1)

How can I publish a non-JSON, non-REST procedure that generates nice webpages (using htp, htf, owa) in ORDS? No schema and no module is ORDS enabled, for the life of me I can't say how it's done.

• oracle-database
• procedure
• oracle-ords
• epg

Share Improve this question Follow edited Jan 29 at 14:07 thatjeffsmith 22.5k66 gold badges4444 silver badges134134 bronze badges asked Jan 29 at 0:24 diprdipr 3955 bronze badges 1

• this is the 'old way', and you can continue doing this, see Koen's answer below, but eventually you're really going to want to go the way you're avoiding (an API that returns JSON, that your clients/apps/pages can then render however they want, vs hard coding the front end in the database) – thatjeffsmith Commented Jan 29 at 14:06

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 2

What you're looking for is called a "pl/sql gateway". The "old" way of serving pl/sql procedures via a web interface was called "mod_plsql". There is a section in the ORDS documentation on how to migrate from mod_plsql to ORDS.