This content has been marked as final. Show 5 replies
Points 2-3 have to be done within your pinging application. I don't know what it is; if it is a commercial solution ask support on how to do that; if it is open source you might ask the developers etc.
thanks man for you reply ,
is not there any other solution ? , a package for pinging ? or subprogram ? ,
i heard that utl_tcp can do this ? and one of it's functions or procedures like open connection func ?
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
I suspect there is nothing running on port 80 (a HTTP Server by default).
I don't know about a ready to use java bean, either you google for it, or you build it on your own.