Triggers, UTL_TCP

From: schw <schwartz_at_alpha.net.pl>
Date: 6 Sep 2006 01:50:11 -0700
Message-ID: <1157532611.072135.100280@i42g2000cwa.googlegroups.com>

Hi,

I've encountered a problem that is caused by lack of my Oracle knowledge. Please help

Here are details:

I've got a java TCP/IP based server that listens on specified port. In my row-level type triggers (delete action) I connect to the server using UTL_TCP and using very simple protocol I want to send column values that users selected.

e.g.

DECLARE

         c utl_tcp.connection; -- TCP/IP connection to the Web server
       n number;
BEGIN
         c := utl_tcp.open_connection('localhost',1232 ); -- open
connection
         n := utl_tcp.write_line(c, 'SET NAME1 SIZE=XX');
         n := utl_tcp.write_line(c, :old:column1);
         utl_tcp.close_connection(c);

END; User wants to send :old:column1 to the server.

The problem is that :old:column1 might be any data type. How can I convert any type to string or maybe to RAW type (and then I could use write_raw method)? How can I get size of data?

thanks for any help

best regards
schw Received on Wed Sep 06 2006 - 03:50:11 CDT