Wallets [message #592195] |
Mon, 05 August 2013 10:30 |
leeweb
Messages: 14 Registered: March 2007 Location: Cardiff, UK
|
Junior Member |
|
|
Hi guys,
Firstly, please accept my apologies if this is in the wrong forum.
I'm trying to invoke a web service using PL/SQL. I have imported the trusted certificate, from our service partner, into the Wallet Manager. I have no certificate requests here, just trusted certificates.
I am then running the following query, just to test it:
select utl_http.request('https://www.callcreditsecure.co.uk/services/bsb/bsb7.asmx'
,NULL
,'file:C:\Documents and Settings\TLASupport\ORACLE\WALLETS'
,'Link0292')
from dual;
This generates the following error:
select utl_http.request('https://www.callcreditsecure.co.uk/services/bsb/bsb7.asmx'
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1577
ORA-28862: SSL connection failed
ORA-06512: at line 1
Our database is installed on a Windows Server 2003 operating system, and I am running the query from this server.
Do I need to restart the database? Or is there something else wrong? Also, apologies if I haven't provided enough information. If you need more, please ask,
Many thanks,
Lee
|
|
|
|
Re: Wallets [message #592224 is a reply to message #592199] |
Mon, 05 August 2013 13:04 |
leeweb
Messages: 14 Registered: March 2007 Location: Cardiff, UK
|
Junior Member |
|
|
Hi Michel, thank you for the reply. I'll try and explain a little more whilst answering your question.
Our development database is hosted on a Windows server. On this server, I created the wallet using OWM, logged in as our development administrator TLASupport. I saved the wallet to the default file location. Now this is where I made the assumption that, as a folder called "wallet" appeared at the location I specified, I assumed this was the right file location. I've then run the query mentioned earlier in a SQL plus session on the same windows server.
Could it be that the windows service for the database is running as a different user to the user that created the wallet? I really am stuck.
Thanks for your time,
Lee
|
|
|
|
|
Re: Wallets [message #592302 is a reply to message #592294] |
Tue, 06 August 2013 06:59 |
|
Michel Cadot
Messages: 68693 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Thanks to let us know the origin of the problem, it might help someone in the future.
Regards
Michel
|
|
|