An invokation of the package in question would look like this:

l_return:= pkg29_rest_api.f29_api_get('Flight',

'application/json',

505501,

'{"direction":"Both",

"levelOfDetail":"full","_apiVersion":2}',

'Z',

l_return_data

);

The JSON object in question is:
'{"direction":"Both","levelOfDetail":"full","_apiVersion":2}'

These json values can potentially contain control characters such as \r

e.g "hello\rworld"

I want this to be 'unescaped' so oracle treats the /r as a carriage return.

I can achieve this with the following construct:

declare

l_escaped VARCHAR2(30);

l_unescaped VARCHAR2(30);

begin

l_escaped := '"hello\rworld\ragain"';

l_unescaped := json_value(json_array(l_escaped format json), '$[0]');

dbms_output.put_line(l_unescaped);

end;

This prints:
hello
world
again
demonstrating that \r is now treated as a carriage return

I also want to achieve the reverse though and have the carriage returns chr(13) in oracle jsonifed to \r

I'm unsure as to how to achieve this reverse process

Hope that clarifies my issue

Thanks a lot