Hi,
We are trying to call a webservice from PLSQL and getting the below error. Anybody can point us what are we missing ?
Note:- This is a e-Buisness database.
DB Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
"CORE 11.2.0.2.0 Production"
TNS for Solaris: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
Steps followed.
1. Downloaded the certificate from the website using Google Chrome and copied to the unix server into the locatoin /tmp/aj/google_cert.cer
https://maps.googleapis.com/maps/api/geocode/xml
2. Created the wallet and added the certificate using the below commands
--Create Directoty
mkdir -p /u41/test/apps/apps_st/appl/fnd/12.0.0/secure/wallet1
--Create Wallet
orapki wallet create -wallet /u41/test/apps/apps_st/appl/fnd/12.0.0/secure/wallet1 -pwd WalletPasswd123 -auto_login
--Add cert to Wallet
orapki wallet add -wallet /u41/test/apps/apps_st/appl/fnd/12.0.0/secure/wallet1 -trusted_cert -cert "/tmp/aj/google_cert.cer" -pwd WalletPasswd123
chmod 777 /u41/test/apps/apps_st/appl/fnd/12.0.0/secure/wallet1/cwallet.sso
chmod 777 /u41/test/apps/apps_st/appl/fnd/12.0.0/secure/wallet1/ewallet.p12
3. Checked the ACL and it looks like below :
select * from DBA_NETWORK_ACLS;
select * from DBA_NETWORK_ACL_PRIVILEGES;
4. Test Code is like below :
DECLARE
l_http_request utl_http.req;
l_url varchar2(1000);
BEGIN
utl_http.set_wallet ('file:/u41/test/apps/apps_st/appl/fnd/12.0.0/secure/wallet1' ,'WalletPasswd123');
l_url := 'https://maps.googleapis.com/maps/api/geocode/xml';
l_http_request := utl_http.begin_request (l_url, 'GET', UTL_HTTP.HTTP_VERSION_1_1);
END;
We saw the below and not sure whether this is the issue we are having.
ORA-28857 tips
Cheers
AJ