Oracle APEX - Table API - For CRUD Operations

Oracle APEX - Table API - For CRUD Operations

[@viswapsp]

This video is very helpful. Thank you for sharing it. A Quick note -> While this is working as expected in recent versions, when we create a Report with a form, a new process called "Close Dialog" is being created in the Processing -> Processes section. When we create the custom processes such as ins_emp, upd_emp, and del_emp, make sure to change the Sequence value (in the Properties -> Execution -> Sequence) to a lower value than that of "Close Dialog" (or increase the sequence of "Close Dialog" to a value higher than the rest). Otherwise "Close Dialog" executes first, and the code specified in the custom processes is not getting executed. Spent lot of time to debug this.

[@swapnilarsul8057]

Thank you for sharing your knowledge 👍

[@crazygamer6402]

I have a have a problem with ORACLE APEX, I created 7 interactive report pages, I can access 6 of them and the one the named ADMINS I can only view the table but when I try to edit it shows this error message: Sorry, this page isn't available. Error process request. Contact your application administrator And same thing for Administration page, it shows the same error message when I try to access it.

[@viswapsp]

Sriram - I am wondering if you tried this method (of using stored procedures) with a table that has a BLOB column. One of my goals is to use all Stored procedures and not to refer table names/column names directly in the Apex application (that way there is a separation of duties, decoupling) between front end (Apex app), and the back end (actual tables). I consider the interface (stored procedures) is the only interaction between front end and back end. I am not sure if I made any sense. If so, I am wondering if you are able to get/put/post blob values from the apex form to the database using the stored procedures. Thanks for your time.