Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with value length when sending JSON over ORDS

dmarinov87May 10 2019 — edited May 19 2019

hi to everyone!

I'm facing a problem with sending JSON over the ORDS.

I'm sending body payload in structure as shown:

{

    "DOCUMENT":{

        "CREATED_BY":"test",

        "SHORT_NOTE":"Test document",

        "FILENAME":"test.jpeg",

        "FILETYPE":"application/jpeg",

        "BASE64_DOC":"around 80k base64 encoded string",

    }

}

And I have a problem with BASE64_DOC because it has a large value. For now, I found out that if I send BASE64_DOC in 4k length it works fine.

Does anyone know what is a problem and how I can send value which is larger than 4k over ORDS?

We are using:

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

PL/SQL Release 12.2.0.1.0 - Production

"CORE    12.2.0.1.0    Production"

TNS for Linux: Version 12.2.0.1.0 - Production

NLSRTL Version 12.2.0.1.0 - Production

ORDS v18.4

Any help would be appreciated!

Best regards to everyone

Dragan

This post has been answered by Olafur T on May 14 2019
Jump to Answer
Comments
Post Details
Added on May 10 2019
7 comments
1,045 views