PL/SQL (MOSC)

MOSC Banner

Corrupt Webservice Response

Hi,

We are currently migrating to Oracle Database 19C at a few different customers. We have run into a strange and showstopping bug. Whenever we call a webservice using https, if the response reaches a certain length, it gets corrupted. We have managed to break this down into a very simple scenario. It's enough to simply download a text file from a webserver:


declare

 l_blob      BLOB;

 wallet_path_v   VARCHAR2(100) := 'file:c:\Wallets';   /* UPDATE THIS VALUE TO WHERE THE WALLET IS LOCATED! */

 wallet_password_v VARCHAR2(100) := '';

  url_v             VARCHAR2(250) := 'https://www.infosystem.ch/files/test.txt';

BEGIN

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center