Pushing data from Oracle using utl_http and node

index.html

<script src="http://code.jquery.com/jquery-1.11.0.min.js"></script>
<script src="/socket.io/socket.io.js"></script>
<script>
    var socket = io.connect('http://www.example.com');
    socket.on('column_value', function (data) {
        console.log(data);
        $('#trigger').html(data.trigger)
        $('#column-value').html(data.column_value)
    });
</script>
Column listener
<p id="trigger"></p>
<p id="column-value"></p>

node_server.js

var app = require('http').createServer(handler),
    io = require('socket.io').listen(app),
    fs = require('fs');
 
app.listen(80);
 
var qs = require('querystring');
var post_data
 
function handler(req, res) {
    fs.readFile(__dirname + '/index.html',
    function(err, data) {
        if (req.method == 'POST') {
            var body = '';
            req.on('data', function (data) {
                body += data;
            });
 
            req.on('end', function () {
                post_data = qs.parse(body);
                if (post_data.trigger == 'trigger_name') {
                    io.sockets.emit('column_value', post_data)
                }
            });
        }
 
        res.writeHead(200, {'Content-Type': 'text/html'});
        res.end(data);
    });
}

trigger.sql

create or replace trigger trigger_name
  after update of column_name on table_name for each row
declare
  req   utl_http.req;
  resp  utl_http.resp;
  v_param varchar2(500) := 'trigger=trigger_name&column_value=' || :new.column_name;
  v_param_length number := length(v_param);
begin
  req := utl_http.begin_request (url=>'http://www.example.com', method=>'POST');
  utl_http.set_header (r => req, name => 'Content-Type', value => 'application/x-www-form-urlencoded');
  utl_http.set_header (r => req, name => 'Content-Length', value => v_param_length);
  utl_http.write_text (r => req, data => v_param);
  resp := utl_http.get_response (r => req);
  utl_http.end_response(resp);
end;

update.sql

update table_name set column_name = 'new value';