Good morning.
I am new to Oracle Apex.
While asking this question, I am assuming myself two roles - PL/SQL Developer, Oracle Apex Form Developer.
As a PL/SQL Developer I have created Packaged procedures/functions to insert/update/delete/select-multi/select-single/lock different entities (for example: Employee/Country etc.). I do not want to expose the table names/view names to my Oracle Apex Developer. My expectation is all the DML actions must be done using these Packaged procedures/functions.
This packaged procedures depending on the need may insert/update/delete data from multiple tables as the information is distributed. However the signatures of the procedures are given to the Oracle Apex Developer (and any signature changes are coordinated).
I am successful to use pipelined packaged functions that return custom PL/SQL table type (as well as SQL table type) to create “Interactive Report” pages.
I am able to use DB Procedures to insert the data by creating “Processes” in the Oracle Apex page. However I do not have good clarity on how the Processes are called from various buttons (such as CREATE/SAVE/DELETE buttons). I am confused to create a consistent mechanism. All that I know is it looks is possible to use Stored procedures for all DML actions.
Do you have any suggestions where someone used DB procedures to have all the control (and almost the Oracle Apex form is used to pass the information entered in the front end screens)?
Please do not suggest to use to use Tables/Views, because that is not what I want to do.
If you would like to see a sample code of the package etc. I will be glad to post that.
Thank you
Viswa