I am trying to process a form with the following setup:
An UPDATE button has been created and added to UPLOAD_FORM form
Action: Submit Page
Execute Validations: Off
Database Action: SQL UPDATE action
A PROCESS_UPLOAD_FOR_U process was created and calls a package procedure, in the database, that will handle the validations & process the form (see file attached below)
PL/SQL Code: PACKAGE.PROCESS_FORM(p_request_type => :REQUEST, ...etc);
Point: Processing
When Button Pressed: UPDATE
Execution Scope: For Created and Modified Rows
I am getting an ORA-06502: PL/SQL numeric or value error when clicking the UPDATE button that runs the PROCESS_UPLOAD_FORM. I was hoping that using the APEX_ERROR API would add the failed validations from the package procedure to the error stack and they would display inline on the form.
For those wondering why I'm doing it this way - My reason is to keep the business logic (validations & processing) outside of APEX. I'm trying to use APEX as the presentation & behavior (DA) layer only.
process_form.txt (4.65 KB)Thanks in advance,
Mike