I have a PL/SQL anonymous block process that calls an oracle procedure On Submit - After Computations and Validations:
The button works and calls the Oracle procedure. My problem is that the process will try to run anytime the page gets submitted due to any other process in the page. The error I am getting when another process submits the page is as follows.
ORA-06502: PL/SQL: numeric or value error: character to number conversion error. ( If I disable the process, the page works and all other processes are submitted successfully).
Does anyone have any ideas? They will be greatly appreciated.
Have you tried adding a condition to the process? I'm not sure what options were available in APEX 3.x (which is really old; the current version is 4.2.4), but in the current versions of APEX there's a specific "When button pressed" field that allows you to specify that the process only fires when a specific button is clicked.