:result := sys.dbms_xmlquery.getxml(sqlquery => 'select var1, var2, var3 from table where ... ',metatype => : null);
Sometimes run, sometimes get an error. My sql is not heavy only gets about 10 records.
I think may be a problem of shared memory, similar to ORA-4031 or ORA-4032.
¿Could be a problem of size in shared memory, java_pool_size?. My values are: