Forum Stats

  • 3,770,265 Users
  • 2,253,087 Discussions


Submit Button in APEX 3.2.1 SQL Query (updateable report)

Sylvia Pagan
Sylvia Pagan Member Posts: 13
edited Feb 28, 2014 9:44AM in Packaged Applications

Hi all,

I am fairly new to APEX.  I have an updateable report and have created a button for every row as follows:

<input type="button" value="Task Complete" onclick="doSubmit('#REF_STEP_ID#');" />

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.

Thank you,




  • Sylvia,

    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.



This discussion has been closed.