Overblog
Editer l'article Suivre ce blog Administration + Créer mon blog

Search

Free tool

Look and Feel Project

31 octobre 2006 2 31 /10 /octobre /2006 17:11
Someone (his/her name is Torben) put a comment on my last java Bean article about how to transform a Forms application into a socket server.

He decided to use the bean to send message from the database:

DECLARE
  c  utl_tcp.connection;  -- TCP/IP connection to the Socket server
  ret_val PLS_INTEGER;
BEGIN
  c := utl_tcp.open_connection(remote_host => '10.40.40.40',
                               remote_port =>  4450);  -- open connection
  ret_val := utl_tcp.write_line(c, 'Incoming Message Send by my Oracle DB');
  utl_tcp.close_connection(c);
END;


Cunning !

The database can, then, send any information message to any particular Forms user like: Hey John, a row has just been created !'


This way, it is easy to imagine a system where several Forms sessions communicate between each other...

Partager cet article
Repost0

commentaires