Skip to Main Content

APEX

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!

apex_json.write and special characters

Boris GirschAug 12 2016 — edited Aug 13 2016

Hi all,

have a following problem. I need to create an object with a filesystem path as a value

{

'path': '/my/path'

}

the problem is that apex_json.write always escapes special characters so I get

{

'path': '\/my\/path'

}

instead. can I avoid escaping somehow ?

declare

v_string varchar2(1000) := '/py/path';

v_out_json clob;

begin

apex_json.initialize_clob_output;

apex_json.open_object();

apex_json.write('my_path',v_string);

apex_json.close_object();

v_out_json := apex_json.get_clob_output;

apex_json.free_output;

dbms_output.put_line(v_out_json);

end;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2016
Added on Aug 12 2016
3 comments
1,192 views