2 Replies Latest reply: Feb 3, 2013 11:29 PM by 972094 RSS

    Run PLSQL code by click on button usin javascript

    972094
      Hi
      I want to run plsql code
      on click button using javascript

      javascript is ok but code of plsql is not run
      suggest me



      APEX 4.2.1
      Oracle !!XE
      Windows Server
      Firefox 17.0.1
      Theme Cloudy

      thanks in advance

      bUTTON CODE IN PLSQL CODE AND SEND_RMNDE IS PROCEDURE

      '<button type="button" name="button1" onclick="send_rmndr('
      ||NO_DUES_MASTER.CERT_ID
      ||');" value ='
      ||NO_DUES_MASTER.CERT_ID
      ||'> '
      ||'Remind'
      ||'</button>'

      JAVASCRIPT
      <script type="text/javascript">
      function send_rmndr(pThis)
      {
      var params='x= '+pThis;

      var get=new htmldb_Get(null,null,null,&APP_PAGE_ID.,null,'send_reminder',params);



      gReturn = get.get();
      //alert(gReturn);
      alert ('inside script ' +params);

      //get=null;

      }
      </script>

      Edited by: 969091 on Feb 1, 2013 9:13 PM