Stack Overflow
Stack Overflow

Questions tagged [nclob]

35 questions
0
votes
0 answers

NCLOB data Table from Oracle to MySQL Data Migration 5.7.38

I am migrating from Oracle to MySQL on AWS RDS. MySQL version is 5.7.38. One of the DB table has data in NCLOB format. While migrating to MySQL the XML data is trimmed in Long Text format. I used AWS DMS tool. Can you recommend how to migrate the…
B J
  • 37
  • 5
0
votes
0 answers

sqoop export hive->oracle error(string/varchar column to clob column)

[Hive side] create table TEST.HIVE_TEST ( CONTENT string) stored as textfile; [oracle side] create table TEST.ORACLE_TEST ( CONTENT clob); [sqoop export] /usr/bin/sqoop export \ --connect "connection…
are123
  • 1
  • 1
0
votes
1 answer

Oracle NCLOB column update query taking long time

I am trying to copy data from CLOB datatype column to NCLOB datatype column in same table. The table has around 25k records. I am trying to update 5k records at a time. It is a simple update query but taking 4mins for 5k records. UPDATE TABLE_NAME…
Sangeetha
  • 3
  • 1
0
votes
1 answer

How to edit a nclob column using Sql Developer

I can't edit a nclob column data type in Oracle Database using SQL Developer :
Raul Mercado
  • 324
  • 1
  • 4
  • 14
0
votes
0 answers

data is missing/getting truncate while copy from NCLOB datatype column in oracle sql devloper

I work on C# application which generate the details of employee and also application activity get logged in to logger in database(oracle sql devloper).so i ran the application its response was about of 1000+ lines and same get logged in to database…
garima mishra
  • 1
0
votes
0 answers

Catchable fatal error: Object of class OCI-Lob could not be converted to string

I have return some code, which returns clob data from database and here I'm trying to display it in front end and ended up in getting some error. Below is my function which returns data Function tabledetails() { $sql = "my_query"; $std =…
Karthik Sanu
  • 11
  • 4
0
votes
0 answers

How to load NCLOB from BFILE to Oracle DB

I am trying to load some data from a file to NCLOB type in Oracle DB. File contains some multi-byte characters. I followed this link and wrote a procedure to do that. But I see that some additional characters are being added to DB. Can anyone let…
user001
  • 991
  • 6
  • 16
  • 34
0
votes
1 answer

NCLOB to VARCHAR2

I am trying to convert a NCLOB to VARCHAR2 in Oracle, but get the following error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 2669, maximum: 2000) Here is the code that I am using: select…
janez_007
  • 91
  • 3
  • 13
0
votes
1 answer

conversion function is required?

In my oracle database contains table Text_Details, field F_TEXT is now an NCLOB field so anywhere this is used in WHERE-clause comparisons may require casting it to other datatypes (NVARCHAR2(4000)probably) for those…
Ram
  • 727
  • 2
  • 16
  • 33
0
votes
0 answers

how to update N data into oracle from mybatis

I am trying to insert/update NCLOB data on oracle using mybatis. But having problem with this. Data type of column is NCLOB and below is the code i used on sqldeveloper to test it. UPDATE CONTENT_TABLE SET HTML_DATA = N'通过信息通信系统的整合' WHERE SEQ =…
Jung Young-min
  • 111
  • 7
0
votes
0 answers

Oracle ORA-22835: Buffer too small for CLOB or BLOB to RAW conversion

I am getting error ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4918, maximum: 4000) on executing below query (both in hibernate and sql editor). UPDATE TABLE set COLUMN = UNISTR(COLUMN) WHERE ID = ID; COLUMN is…
Maz
  • 653
  • 12
  • 22
0
votes
0 answers

Error getting NCLOB cyrillic value

This is my problem: DECLARE my_clob NCLOB; BEGIN FOR rec IN ( SELECT CLOB_TEXT FROM MY_TABLE a WHERE CL_LANGUAGE = 'ru') LOOP my_clob := rec.CLOB_TEXT; DBMS_OUTPUT.PUT_LINE(my_clob); END…
MrGreen
  • 61
  • 1
  • 2
  • 4
0
votes
0 answers

dbunit inserts junk values for NCLOB column

I am facing a problem which is independent of dbunit jar versions as I have tried with dbunit-2.0.jar, dbunit-2.2.1.jar, dbunit-2.4.9.jar, dbunit-2.2.3.jar and dbunit-2.3.0.jar and independent of Oracle Database version, as I tried on oracle11g and…
Harish Vashist
  • 86
  • 7
0
votes
1 answer

Update NClob using N Function issues

I am using N function to update NClob in SQL Query. However, the update using N function is not allowing me to update more than 1900 characters. After removing N function. I am able to update the more than 1900 characters to my NClob column. Can…
user1661892
  • 103
  • 4
  • 13
0
votes
1 answer

Convert from VARCHAR2 to NCLOB (oracle)

I got a column message with data_type = VARCHAR2. It already has some data stored. I want this column to be of type NCLOB. Code-Set for this column should be UTF-8. I did the following: added a column tempmessage to my table of type NCLOB filled…
Chris311
  • 3,794
  • 9
  • 46
  • 80
1
2
3