How to send SMS from ORACLE forms 10g

Here's how to send sms message from Oracle application.



Explain:



Say we are subscribed to msegat.com service with the following credentials:



User Name : OMAR

Password :  123

User Sender : ThreeM    ( you got it from your sms site)

Text we'll send : My_Test_Message

Phone we'll send message to : 966123456789



Here's how the code will run:

/*Start of SMS code*/

SET serveroutput ON
SET Define OFF
 
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!   
 
UTL_URL.Escape(SMS_MSG,TRUE);
--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;
/*End of SMS code*/


If you got an error , you can remove :

SET serveroutput ON
SET Define OFF




"و فوق كل ذي علم عليم"

Installing WebLogic 11g

Oracle Weblogic 11g is the new generation of Oracle Forms10g.

FMW (Oracle Fusion MiddleWare  )  is newer than Forms10g.

I found Weblogic more easier to run Oracle  Application over network and internet also.

Here's my steps I did to install both of Weblogic 11g  and FMW.

Windows Server 2003 is recommended

1# Install Oracle DB 10g or 11g    here's my howto



2# Download and Install Weblogic 10.3.6.0 (Direct link...)



3# Download FMW (Links in attached PDF...)



4# Install FMW first part (file consists of 4 parts)

While installing ...make sure to check option :Install software-Do not configure



5# Install FMW Patchset file (file consists of 3 parts)



6# Copy tnsnames.ora file 

from:  C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora

To C:\oracle\Middleware\as_1





7# Configure Software :

Oracle Classic11g-Home1  then  Configure Classic Instance

While installing ...make sure to Uncheck option :Oracle Portal and  Oracle Discoverer

Make sure to save configuration in text file as you need it later.



8# Run both of  NodeManager  and wait until the word  port appears



9# Run both of  Start WebLogic and wait until the word  Running mode appears



10# Login to Weblogic Web interface ( It's always PC-Name:7001/console)

from the left corner select Environment then Servers then choose Control tab ,then  select WLS_FORMS and WLS_REPORTS  then  press Start button.



11# If Forms don't run well , then you can :



  • download Java J8u92
  • edit Formsweb.cfg to adapt with java
  • Add exception for forms site in Java application
Thanks to : 

Install Microsoft Loopback Adapter in Microsoft Windows Server 2003

You may need to make your IP static ,  to make sure reports run well .
So you should install the Microsoft Loopback Adapter by using the Hardware Wizard, follow these steps:
  1. In Control Panel, double-click Add Hardware, and then click 
    Next
  2. Click Yes, I have already connected the hardware, and then click 
    Next.
  3. At the bottom of the Installed hardware list, click Add a new hardware device, and then click Next.
  4. Click Install the hardware that I manually select from a list, and then click Next
  5. In the Common hardware types list, click Network adapters, and then click Next.
  6. In the Manufacturers list box, click Microsoft.
  7. In the Network Adapter list box, click Microsoft Loopback Adapter, and then click Next.
  8. Click Next to start installing the drivers for your hardware.
  9. Click Finish.
  10. Click Start, click Settings, and then click Network Connections to verify that the Microsoft Loop-back Adapter has been installed.
Here's How to install Loop-back adapter on other windows and how to install Oracle ArabOUG

Source : How to install the Microsoft Loopback Adapter in Microsoft Windows Server 2003