0 Replies Latest reply on Jun 1, 2006 5:43 AM by remmer

    UTL_HTTP Unknown SSL Error - end of our tether...

    remmer
      Hi all - can anyone shed light on this please.

      We're trying to implement the following call using UTL_HTTP to a https-based site (in fact web service):

      select utl_http.request ('https://###Secure URL###', '##PROXY URL##',
      '###WALLET LOC###', '###WALLET PASSWORD###') from dual;

      We followed the recommendations of Metalink note 169768.1 and obtained the necessary certificate from the site and loaded it into our Wallet Manager. We have had success with a couple of test https URLs and their associated certificates, such as:

      https://metalink.oracle.com
      https://scgi.ebay.com/ws/eBayISAPI.dll?RegisterEnterInfo

      However when we try the actual Web Service endpoint URL that we need, we get the following error:

      ERROR at line 1:
      ORA-29273: HTTP request failed
      ORA-06512: at "SYS.UTL_HTTP", line 1577
      ORA-28857: Unknown SSL error
      ORA-06512: at line 1

      The ORA-28857 error has no information to support its resolution - its one of the 'you shouldn't get this'-type messages. Can anyone shed any light on this? The URL we're trying to reach is: https://hts.maynegroup.com/pharmacy_ordering_dev/PO.asmx

      Any help or suggestions are welcome. Our only thought is that the certificate is somehow invalid...

      Kind regards
      Dennis