HTTPS call :
SELECT APEX_WEB_SERVICE.make_rest_request (
p_url => 'https://wsctt.xyz12345.com/cxfws2/services/Ping',
p_proxy_override => 'http://www-xyz-abc7.us.sss.com:80',
p_http_method => 'GET',
p_wallet_path => 'file:/u01/app/oracle/dba/rdbms/orcl/wallet7',
p_wallet_pwd => 'Welcome123')
FROM DUAL;
SELECT UTL_HTTP.request (
url => 'https://wsctt.xyz12345.com/cxfws2/services/Ping',
proxy => 'http://www-xyz-abc7.us.sss.com:80',
wallet_path => 'file:/u01/app/oracle/dba/rdbms/orcl/wallet7',
wallet_password => 'Welcome123')
FROM DUAL;
Note: certificate has to be installed in a wallet and that wallet path is required for https calls
HTTP call:
SELECT UTL_HTTP.request (
url => 'http://www.google.com',
proxy => NULL,
wallet_path => NULL,
wallet_password => NULL)
FROM DUAL;
Example:
SQL> SELECT UTL_HTTP.request (url => 'http://www.google.com',
proxy => NULL,
wallet_path => NULL,
wallet_password => NULL)
FROM DUAL; 2 3 4 5
UTL_HTTP.REQUEST(URL=>'HTTP://WWW.GOOGLE.COM',PROXY=>NULL,WALLET_PATH=>NULL,WALL
--------------------------------------------------------------------------------
<!doctype html><html itemscope="" itemtype="http://schema.org/WebPage" lang="en-
IN"><head><meta content="text/html; charset=UTF-8" http-equiv="Content-Type"><me
ta content="/logos/doodles/2019/hans-christian-grams-166th-birthday-489939712815
9232-l.png" itemprop="image"><meta content="Hans Christian Gram’s 166th Bi
rthday" property="twitter:title"><meta content="Hans Christian Gram’s 166t
h Birthday! #GoogleDoodle" property="twitter:description"><meta content="Hans Ch
ristian Gram’s 166th Birthday! #GoogleDoodle" property="og:description"><m
eta content="summary_large_image" property="twitter:card"><meta content="@Google
Doodles" property="twitter:site"><meta content="https://www.google.com/logos/doo
dles/2019/hans-christian-grams-166th-birthday-4899397128159232-2x.jpg" property=
"twitter:image"><meta content="https://www.google.com/logos/doodles/2019/hans-ch
UTL_HTTP.REQUEST(URL=>'HTTP://WWW.GOOGLE.COM',PROXY=>NULL,WALLET_PATH=>NULL,WALL
--------------------------------------------------------------------------------
ristian-grams-166th-birthday-4899397128159232-2x.jpg" property="og:image"><meta
content="1200" property="og:image:width"><meta content="393" property="og:image:
height"><title>Google</title><script nonce="1rUWEIjDIfCXdUPikzk5jw==">(function(
){window.google={kEI:'h-J7XY6EJNqmwgPhpLiwCw',kEXPI:'0,18167,1335579,5663,731,22
3,510,19,1046,3151,379,206,1017,53,1431,577,2,124,10,713,226,112,538,245,1131683
,1197921,246,302938,26305,1294,12383,4855,32692,15247,867,12163,6381,854,2481,2,
2,6801,369,3314,5505,224,2215,5945,1119,2,579,727,2431,1362,284,4039,3698,1269,7
74,2247,1410,2487,1996,9,981,982,6196,669,1050,1808,1478,7,3,472,16,2044,5762,1,
3146,5072,223,2018,38,920,873,1217,1336,28,1611,2736,1558,1503,2,215,1,415,1137,
1,1265,837,7194,252,620,2883,19,1,319,234,455,429,904,1150,975,1,371,2777,517,40
0,992,509,196,580,9,108,2687,885,82,48,553,11,14,1279,2212,202,37,130,157,4,68,1
UTL_HTTP.REQUEST(URL=>'HTTP://WWW.GOOGLE.COM',PROXY=>NULL,WALLET_PATH=>NULL,WALL
--------------------------------------------------------------------------------
184,327,513,324,194,793,680,48,820,2620,818,109,151,52,1132,4,3,2063,606,1839,18
4,595,366,959,377,361,141,184,1261,749,59,368,44,207,1,781,113,328,1284,16,84,33
6,81,507,267,1510,142,2247,100,146,227,11,1328,29,700,501,557,669,2215,210,13
SQL>
No comments:
Post a Comment