1 Reply Latest reply: Feb 26, 2013 10:58 AM by riedelme RSS

    Using the same page for update and insert

    inka
      Hello All,

      I have a page that was created by using an interactive report. The report lists values and these values are links. When I click on the link it takes me to the page where the data is displayed for the particular item. The report page also has a button that alow the user to enter new item. However, when I click on that button I get an error message:

      ORA-01403: no data found

      I am using APEX 4.2 and Oracle 11g.

      How can I fix it?
        • 1. Re: Using the same page for update and insert
          riedelme
          inka wrote:
          Hello All,

          I have a page that was created by using an interactive report. The report lists values and these values are links. When I click on the link it takes me to the page where the data is displayed for the particular item. The report page also has a button that alow the user to enter new item. However, when I click on that button I get an error message:

          ORA-01403: no data found

          I am using APEX 4.2 and Oracle 11g.

          How can I fix it?
          How are you processing the insert/update? Manually with a validation or automatically through generated routines?

          If you are manually doing the insert or update you can link the request to the validation and perform an insert when an insert button is pressed or an update when an update button is pressed. Or use one routine and perform a MERGE.