2 Replies Latest reply on Jan 31, 2016 5:33 AM by Kalpataru

    SRW package on 12c

    Scott Wesley

      Hi,

       

      We've upgraded to 12c from 11g and when attempting to execute reports using the SRW package we now face the following error:

       

      ORA-20212: 
      ORA-06512: at "OUR_SCHEMA.SRW", line 648
      ORA-29273: HTTP request failed
      ORA-29276: transfer timeout
      

       

      Adding the ACL avoided the network access denied error, but the report now (intermittently) fails with this timeout error.

       

      Is there an updated version of this package we should compile?

      We've been working hard to try eliminate other factors.

      It's executed via PL/SQL in an APEX session, and we've had no issues on 11g with this process.

       

      Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

      Windows server

      ORDS 3.0.0

      Web Logic Server 11g

      Oracle Reports 11g

       

      Scott.