How to Send Automated WhatsApp Messages from Oracle APEX (The Modern Way)

The Challenge: Beyond Standard Emails In modern ERP and CRM systems built on Oracle APEX, email notifications are no longer enough. Customers want real-time updates—order confirmations, shipping alerts, and OTPs—delivered directly to WhatsApp . While you can use UTL_HTTP , the modern standard for APEX developers is APEX_WEB_SERVICE . It’s cleaner, handles CLOBs better, and simplifies the REST call. Method 1: Using APEX_WEB_SERVICE.MAKE_REST_REQUEST (Recommended) This is the most efficient way. It integrates directly with the APEX engine and makes handling JSON payloads a breeze. DECLARE l_response CLOB ; l_url VARCHAR2 ( 400 ) : = 'https://api.waaibot.com/api/v1/send' ; l_api_key VARCHAR2 ( 100 ) : = 'YOUR_API_KEY' ; l_body CLOB ; BEGIN -- Constructing the JSON Payload l_body : = '{"number": "923001234567", "message": "Your Order #1029 is ready for dispatch!"}' ; -- Setting headers and making the request apex_web_service . g_request_headers ( 1 ). name : = 'Content-Type' ; apex_web_ser