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!

ORDS 18.4 Why am I getting an empty :body_text (CLOB)?

qskyhighFeb 21 2020 — edited Mar 4 2020

Hello,

Tell me, please, why does the empty value come?

To send a request, I use SoapUI 5.5.

But :body is not null.

Do I need to do something in the settings of ORDS?

DECLARE

    --b_body BLOB := :body;

    c_body CLOB := :body_text;

BEGIN

    if :body_text is null then

    htp.print('EMPTY');

    end if; 

END;

This post has been answered by Capt. Egg on Mar 3 2020
Jump to Answer
Comments
Post Details
Added on Feb 21 2020
13 comments
1,529 views