Good morning.
As we know most of the Apex Developers are good at SQL and PL/SQL and like to write Procedures/Functions/Packages to have good control (in a good way) on the functionality.
I would like to understand how to replace standard/typical processing with packaged procedures that actually do the following.
For example: I have procedures to do all the below functionality.
- get (a PIPELINED function that returns the record(s) (using a “TableType” (defined in a package spec OR using CREATE or REPLACE TYPE syntax) based on the search criteria)
- post (that inserts single record, as well as multi records by accepting “TableType” parameters (for example: create or replace type customer_Tab as table of customer_record)
- put (that accepts record(s) and map record(s) (Map record is record that contains indicators which fields have to be updated),
- delete (that accept record(s) that contain DELETE criteria
- lock (contains a criteria) that locks record(s)
Even though I know how to create REST services (using ORDS), first I would like to understand how to replace the typical processing with my own procedures as specified above. (I have not used REST in Apex yet, even though I have created REST services using ORDS).
I am sure this question mostly come up several times in the past. So, any help to point me to any of those posts is greatly appreciated.
Basically I want to separate physical design of the structures (tables etc.), so the table names etc. are not used in the front end.
Please let me know if my question is not clear, so I can provide more details (or a example code)
Thank you for looking at this post.
-Viswa