2 Replies Latest reply: May 2, 2012 5:25 AM by Neeraj Sehgal RSS

    pl/sql call to a WS: HTTP request error

    user575818
      Hello,
      I am trying to call a web service from a pl/sql package and am getting this error from the Apps (10g database)

      ORACLE error 29273 in FDPSTP

      Cause: FDPSTP failed due to ORA-29273: HTTP request failed
      ORA-06512: at "SYS.UTL_HTTP", line 1029
      ORA-28862: SSL connection failed
      ORA-06512: at "APPS.CM_TEST_WS_INVOKE", line 19
      ORA-06512: at line 1

      Could anyone help me resolve this so that I can call the web service?
      Any help would be greatly appreciated.

      -CC

      Edited by: user11121346 on May 1, 2012 10:17 AM
        • 1. Re: pl/sql call to a WS: HTTP request error
          Patrick Taylor
          ORACLE error 29273 in FDPSTP

          Cause: FDPSTP failed due to ORA-29273: HTTP request failed
          ORA-06512: at "SYS.UTL_HTTP", line 1029
          ORA-28862: SSL connection failed
          ORA-06512: at "APPS.CM_TEST_WS_INVOKE", line 19
          ORA-06512: at line 1
          Looks like the webservice call is made via HTTPS. Did you make the necessary SSL setup to invoke the webservice securely?

          Thanks,
          Patrick
          • 2. Re: pl/sql call to a WS: HTTP request error
            Neeraj Sehgal
            Hi,

            As this is a SSL call, you need to configure the wallet. Basically if it is a One-way SSL (only webservice server gets authenticated), you need to follow the following steps.

            1.) Extract the Public Certificate of the Target Web service from using the browser
            2.) Import this certificate in the Oracle Wallet using Oracle Wallet Manager
            3.) The schema user trying to invoke the service should have proper ACL permissions
            4.) Test your connection from the R12 SQL directly using below SQL statement. If below is success you can wrap the service call in a package.
            select utl_http.request('https://<service URL>',
            NULL,                     --Proxy Settings if any
            'file:<Wallet_Location>', -- on R12
            <Wallet_Password>
            )
            from dual;
            Let me know if you still face any issues.

            Regards,
            Neeraj Sehgal