Calling Web service from sql

==============================================
select
substr(x,instr(x,'ZONE')+5,1) timezone
from ( select utl_http.request('http://www.yyyyyyy.net//yyyy.asmx/GetInfoByZIP?USZip=97006') x from dual));
==============================================

Query to get dependencies on an object till n level

Query to get dependencies on an object till n level
=============================================
SELECT DISTINCT a.referenced_name main_parent, a.NAME main_child,
b.referenced_name next_level_parent, b.NAME next_level_child
FROM all_dependencies a, all_dependencies b
WHERE 1 = 1
AND b.referenced_name = a.NAME
AND a.referenced_name IN
('YYY_CIB_FLAGS_AGV',
'YYY_CIB_AGV',
'YYY_SLA_HOURS_AGV',
'YYY_SPL_PARTS_AGV'
)
ORDER BY 1, 3
==============================================