1 Reply Latest reply: Feb 28, 2014 8:44 AM by David Gale-Oracle RSS

    Submit Button in APEX 3.2.1 SQL Query (updateable report)

    Sylvia Pagan

      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:

       

      BEGIN

      tta_pkg.p_task_complete(:REQUEST);

      END;

       

      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