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.
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.
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.
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.
Thank you for sharing your knowledge 👍
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.
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.