We are migrating our servers from 11g to 12.2.1.4
Have some reports which we run to file from plsql , using the good old srw package … We throw the call to the reports server at 9002 port and it works, but now they want it secure, so we have to submit it through the ohs server with https protocol.
If we change the gateway, we get ORA-29024 Certificate validation failure, which is normal as https implies certificates.
The question:
How can I tell SRW where is the wallet with the trusted root certificate?
Is there another - up to date - way to submit a report job from plsql ?