Stack Overflow
Stack Overflow

Questions tagged [clob]

Character Large Object - SQL data type used to store character strings longer than the regular CHAR and VARCHAR types allow.

Character Large Object - SQL data type intended to store character strings longer than the regular CHAR and VARCHAR types handle.

See also NCLOB data type which is recommended for storing National Character strings/Unicode.

Oracle: CLOBs are stored externally and are referenced from table, so using them involves performance hit in comparison to using VARCHAR2. In exchange they have very high size limits, depending on exact version of RDBMS but not smaller than 2 GB.

Main difference between CLOB and BLOB data type is that CLOB has defined character encoding and to limited extent can be compared to strings, indexed and searched.

1067 questions
-1
votes
2 answers

How to replace a value to the current payload in mule

I have retrieved some values from the Database. Out of which one field is of type CLOB and that needs to be decoded. I have fetched the value and decoded it successfully. Now I need to set the decoded value to a particular field of the payload.…
mani24991
  • 23
  • 6
-1
votes
2 answers

ORACLE - Dynamic Sql using CLOB

I have a table as described below SQL> desc tab_script Name Null? Type ----------------------------------------- -------- ---------------------------- SRLNO …
Chandrashekhar BC
  • 29
  • 1
  • 2
-1
votes
2 answers

DB2 query for fetching clob value

In DB2 , how do we write a query to fetch value from clob datatype column
P.E
  • 19
  • 1
  • 5
-1
votes
2 answers

Java XML To String for Large File

i have large XML Files over 100MB and more.I use this code. StringWriter writer = new StringWriter(); DocumentBuilderFactory domFact = DocumentBuilderFactory.newInstance(); DocumentBuilder builder =…
ceeleP
  • 21
  • 1
-1
votes
1 answer

Store large data into Oracle field

Can anyone tell me about how to store large data from vb.net to oracle field. I tried in blob as well as clob. but it is always showing error: ORA-01704: string literal too long.
Vetri Chelvan Indrajith
  • 31
  • 6
-1
votes
1 answer

Reading the clob data into flat file using shell scripting in UNIX

I am reading the multiple clob data records from DB into file in UNIX using the shell scrpiting. CLOB1:- COUNTRY AUSTR CLOB2:- ALIA WON THE CLOB3:- WORLCUP THRICE Query fetched the clob like as below. When word is continued in next clob there is a…
sree kanth
  • 1
  • 1
-1
votes
1 answer

make CLOB backup column

i got a 3 CLOB columns , i have to manipulate them and to recreate data i tryed to make backup columns, like this: update tbl_order_webform set mail_bak = mail_html but the back up column is empty after the script. is this even possible? or is this…
Barta Tamás
  • 889
  • 4
  • 15
  • 36
-2
votes
1 answer

How to insert huge html content into Oracle table

I have following huge HTML string and I need to insert it into Oracle table. What is the most suitable data type to store those data? I searched on google and found some source, Clob is most suitable for that. is it correct? If Clob but How can I…
Gamma
  • 317
  • 1
  • 6
  • 22
-2
votes
1 answer

How to use one CLOB output as column in another CLOB in Stored Procedure?

I am just writing small part of stored procedure, Consider following as StoredProc mainQuery CLOB := 'select name, no from main_table od '; subQuery CLOB := 'select LISTAGG(address, '||''','''||') within group (ORDER BY address) from sub_table sb…
Xio Xim Jin
  • 11
  • 1
-2
votes
1 answer

Oracle SQL to list all occurrences of string in Clob/Blob Field

I have a field in my Oracle table "Table1" with Column "texta" which has all my codes written. I would like to extract all the occurrences which matches the patter "record." or "Record." and list the result. For example:- Content of…
Rohit Prasad
  • 135
  • 2
  • 12
-2
votes
1 answer

Create a BLOB/CLOB to save excel files into DB2

I would like to know how can I save several excel files into DB2 using a blob/clob object. Can anyone try to explain me how to reach the goal or redirect me to some documentation or similar issues? Thank you for your time.
Raul
  • 115
  • 5
  • 16
-2
votes
1 answer

Using CLOB gives ORA-06502: PL/SQL: numeric or value error

Code below throws me an error: "ORA-06502: PL/SQL: numeric or value error ORA-06512: at line 24". DECLARE v_clob CLOB; CURSOR cur_a IS SELECT device_num, Account_number, CustomerName, Prem_address , contact_phone , W_status , …
Devadas Wagle
  • 37
  • 1
  • 1
  • 5
-2
votes
1 answer

How to return CLOB datatype as output Parameter in Oracle stored procedure?

I want to return an output param of CLOB datatype(XML data) from an oracle stored procedure. My procedure looks like this create or replace PROCEDURE myProcedure ( myParam1 IN NUMBER ,myParam2 IN NUMBER ,myParam3 OUT CLOB ) AS xml_bits…
Santosh
  • 2,355
  • 10
  • 41
  • 64
-2
votes
1 answer

Storing a CLOB data from a table in a variable in Oracle SQL

Let's say I have a column named "changedetail" with datatype "CLOB" in a table called "changelog". Now, I want to store the value of "changedetail" in a new variable say "loginfo" when a column named "changeuid" is say "ABC1234" . Please can someone…
Dipanshu Awasthi
  • 115
  • 1
  • 2
  • 14
-2
votes
1 answer

query to add data into "CLOB" column

"INSERT into FOLDET (FOLDER_ID, FIELD_NAME, OP_VALUE, " + "FIELD_VALUE, FOLDER_FIELD_TYPE, DISPLAY_FLAG ) values \n" + "( ?, ?, ?, ?, ?, ?) \n" ; we use the above query to insert values into the table FOLDET for column FIELD_VALUE…
vemak
  • 33
  • 8
1 2 3
…
71
72