ORDS, SODA & JSON in the Database

Hi everyone,

I have a piece of code similar to this:

DECLARE

   miCLOB  CLOB;

   l_object   json_object_t;

   l_name      json_element_t;

BEGIN

   miCLOB  := '{"name":"Spñder"}';

   l_object := json_object_t(miCLOB);

   l_name := l_object.get ('name');

   DBMS_OUTPUT.put_line (l_name.to_string);

END;

When JSON string contains characters like ñÑáéíóúÁÉÍÓÚ an ORA-40441 is raised.

I have tested this code in liveSQL and is working fine, so I suppose that is a problem with my environment.

What should I check/change in my environment?

I am using  "Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production".

Thanks !