2 Replies Latest reply on Aug 10, 2019 8:11 AM by iTech Solutions

    send sms through cellular network(zong,telenor) in oracle using pl sql

    3991575

      Hi Exports, I am new in oracle, i want to send sms through cellular network(zong,telenor) in oracle using pl sql and i am using code on when-button-pressed trigger

      DECLARE

          HTTP_REQ      UTL_HTTP.REQ;

          HTTP_RESP     UTL_HTTP.RESP;

          URL_TEXT      VARCHAR2(32767);

          URL VARCHAR2(2000);

          

           SMS_MSG VARCHAR2(160) := 'Congratulations! Your database has been configured propoerly for sending SMS through a 3rd party SMS Gateway';

          

      BEGIN

          DBMS_OUTPUT.ENABLE(1000000);

      --Based on your service provider, the following link format may differ from

      --What we have specified below!   

      --for sending quick message to multiple numbers

       

      URL := 'https://xxxxx.xxx.xx:27677/corporate_sms2/api/auth.jsp?msisdn=xxxx&password=xxx  '

       

      --UTL_URL.Escape manages escape characters like SPACE between words in a message.

          

        

       

          HTTP_REQ  := UTL_HTTP.BEGIN_REQUEST(URL);

         

          UTL_HTTP.SET_HEADER(HTTP_REQ, 'User-Agent', 'Mozilla/4.0');

          HTTP_RESP := UTL_HTTP.GET_RESPONSE(HTTP_REQ);

       

          -- Process Request

          LOOP

              BEGIN

                  URL_TEXT := null;

                  UTL_HTTP.READ_LINE(HTTP_RESP, URL_TEXT, TRUE);

      DBMS_OUTPUT.PUT_LINE(URL_TEXT);

       

                  EXCEPTION

                      WHEN OTHERS THEN EXIT;

              END;

          END LOOP;

       

      UTL_HTTP.END_RESPONSE(HTTP_RESP);

      END;

       

      ***Moderator action (Timo): obfuscated the URL given in the code as the original URL is considered spam.***

       

       

       

      but got this error when-button-pressed trigger raised unhandled exception ora-26273

      and not understand,
      i don't know either it is write on not . kindly give my any hint or step by step procedure or any fmb file

       

      Thanks in Advance

      Regards: Ace Mirxa