I have a column type CLOB that stores an array of objects containing the following structure: {“id”: number, “name”: string} Then suppose we have the following column of CLOB records: [{“id”: 21, “nombre”: “fisica”}, {“id”: 16, “nom…
Tag: clob
finding if a line starts with a specified string in a clob and then extract
I have a CLOB column that I want to search for a line that starts with ‘305’ then extract something from that line, some of my rows will have multiple lines that start with ‘305’ or ‘305 somewhere in the entire cell, so I’d only want to find the first line where it starts w…
ORA-00932: inconsistent datatypes: expected – got CLOB – while using clob in regexp_substr function
I am trying to use CLOB variable in regexp_substr function as below clob_variable is of type CLOB and contains ~ separated ids. While executing the update statement I am getting below error: ORA-00932: inconsistent datatypes: expected – got CLOB Can we use CLOB with RegExp? If not, is there any way to c…
Define a CLOB input parameter for Oracle function (OR Define a function with CLOB input parameter)
I am going to run a code block like below: In which its purpose is to create a function that one of its input argument is CLOB data type. But by executing my code, I get following error: ORA-01704: string literal too long I searched on the internet and also among stackoverflow questions but it didn’t ge…
Handle a very large string in pl/sql script
I am trying to run below code which reads the index definition for table A so that it can be created again after I delete/create that in this script. This script runs fine when the returned value(ddl) …
Defining size of CLOB in Oracle
I am making a table in which I am storing XML. To store XML I am using CLOB data type. The max size of my XML would be 5kb. What size of CLOB column should I define while creating the table? Answer you don’t define a size exactly when setting a clob (unlike a varchar). it is just simply clob.