test.sql

使用Oracle 外部過程發送email, 有裝java組件的Oracle不需要.

declare
sock  number ;
begin
	select  utl_socks.hostconnect('172.17.94.9',80) into sock  from dual ;
	dbms_output.put_line('socket:'||to_char(sock)) ;
	select utl_socks.socketclose(sock) into sock from dual ;	

end ;