PL/SQL (MOSC)

MOSC Banner

ora-06512 in dbms_lob.read

edited Sep 19, 2019 5:05AM in PL/SQL (MOSC) 4 commentsAnswered

Hi All,

This is part of procedure that sends email from our database.

WHILE(offset < v_request_length) LOOP

        dbms_lob.read(j_request, amount, offset, buffer);

        r_req:=utl_raw.cast_to_raw(buffer);

  utl_http.write_raw (req,r_req);

  offset := offset + amount;

  END LOOP;            

The procedure sends a json request using utl_http.

We have weird case,

when "j_request" parameter is: Req: {"to":["AAA@BBB.COM"],"subject":"p","text":"ג","attachments":[]}  (value of "subject" field has English characters and "text" field has Hebrew characters or opposite) then email is sent without any errors,

but when "j_request" parameter is: Req: {"to":["

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