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