1 Reply Latest reply: Feb 6, 2013 10:57 PM by 714270 RSS

    ISSUE WITH SAMPLE POPUP

    Gor_Mahia
      All,
      Iam trying this sample in the url from Denes Kubicek
      http://apex.oracle.com/pls/otn/f?p=31517:257:4044366874569::NO:257::

      at times i get popup but entering and clicking save it errors and after that the popup doesnt work or popup again so i logout to clear my session and log back in but still it doesnt work. I need help with this pls?


      ===>I made the changes to popup but saving doesnt work?
      pls have a look at my sample
      wkspace=proj2010
      user/pwd=demo123/demo123
      appid/page=760/page17 clicking=search


      regards,

      Edited by: Gor_Mahia on Feb 6, 2013 8:35 PM
        • 1. Re: ISSUE WITH SAMPLE POPUP
          714270
          Gor_Mahia wrote:
          All,
          Iam trying this sample in the url from Denes Kubicek
          http://apex.oracle.com/pls/otn/f?p=31517:257:4044366874569::NO:257::

          at times i get popup but entering and clicking save it errors and after that the popup doesnt work or popup again so i logout to clear my session and log back in but still it doesnt work. I need help with this pls?


          ===>I made the changes to popup but saving doesnt work?
          pls have a look at my sample
          wkspace=proj2010
          user/pwd=demo123/demo123
          appid/page=760/page17 clicking=search


          regards,

          Edited by: Gor_Mahia on Feb 6, 2013 8:35 PM
          The problem was with your on demand application process - addEmpGarbage. You had this in the pl/sql code:
          BEGIN
             INSERT INTO emp
                         (ename, job, mgr, hiredate, sal,
                          comm, deptno
                         )
                  VALUES (:p257_ename, :p17_job, :p17_mgr, SYSDATE, :p17_sal,
                          :p17_comm, :p17_deptno
                         );
          EXCEPTION
             WHEN OTHERS
             THEN
                HTP.prn ('Error adding record to the EMP_GARBAGE Table. / ' || SQLERRM);
          END;
          Look at the value being passed for ename column - it is p257_ename.
          I changed it to p17_ename.


          Thanks,
          Rohit