This content has been marked as final. Show 5 replies
i heard that utl_tcp can do this ? and one of it's functions or procedures like open connection func ?If you heard it from somewhere why didn't you go ahead and try it yourself (maybe look it up in the documentation fist) and see if it suits you instead of posting incomplete informations on what/how you want to do?!?
utl_tcp will establish a connection to a specific port; if you are sure you have an application answering on a specific port (e.g. SMB should be available on most windows hosts: http://en.wikipedia.org/wiki/Server_Message_Block) it might suit you. However; if the database server resides in a different network then your clients this might not be what you want. There are other options like java beans, using the java importer,...
i've tried to use it like it is in the example : , i used only the first two parameters
by the way , before i posted the thread , i've tried it , but i faced problems while executing it , that's why i asked if it is
DECLARE c utl_tcp.connection; -- TCP/IP connection to the Web server BEGIN c := utl_tcp.open_connection(remote_host => 'www.acme.com', remote_port => 80); end ;
suitable for me or not .
when i execute it by the above code , the engine tells me that "procedure successfully completed , but without any result .
2- if you could tell me what does "remote_port" means , because i posted the number in the example as it is .
i do not know what is port ?
3- do you know about a jave bean can do my requirements ?
thanks a lot