APEX to call mod/plsql package in the database to render dynamic web pages
698452Apr 29 2009 — edited May 1 2009Not sure if this is possible with APEX- however would also like to know if you can do this with the full blown database.
I have a stored procedure that utilizes the pl/sql packages that contain http calls.
I want to have this package run and render the web pages. The package is dynamic and allows users to create their own queries after selecting a table.
I see how to put an anonymous block into your page. How do you reference a stored package/procedure that is store in the database?
In Oracle app server the url is something like
http://machine.com:7778/dad/myproc.main
How do you put this into an Apex page?
Reason for this- move the application from using 9ias- (which is only using the http server piece) to something else.
The package is completely dynamic and would take a lot of effort to rewrite.
Thanks