Questions tagged as 'clob'

I request your collaboration to indicate how I can concatenate more than one VARCHAR2 in a SELECT , this VARCHAR2 has a more than 4000 characters therefore this error comes out: [Error] Execution (31: 64): ORA-01489: el res...

I have trouble calling a REST-GET service that uses a procedure that returns a CLOB in JSON. When the result has some records, it works fine, but if there are many, it locks. Oracle 12.1 I have defined a table with postal codes. In this, f...

I am trying the code to consult a table, I get the result as XML I convert it into JSON format, and I show it on the screen to perform tests. My problem is that, by showing the JSON in varchar format (with GetStringVal) it works fine, but if the...