Stack Overflow
Stack Overflow

Questions tagged [nclob]

35 questions
48
votes
8 answers

Error : ORA-01704: string literal too long

While I try to set the value of over 4000 characters on a field that has data type CLOB, it gives me this error : ORA-01704: string literal too long. Any suggestion, which data type would be applicable for me if I have to set value of unlimited…
hsuk
  • 6,770
  • 13
  • 50
  • 80
4
votes
3 answers

Oracle starts to do full table scans when a column is changed from varchar to nclob

I have a table with about 100.000 rows that used to look more or less like this: id varchar(20), omg varchar(10), ponies varchar(3000) When adding support for international characters, we had to redefine the ponies column to an nclob, as…
KarlP
  • 5,149
  • 2
  • 28
  • 41
4
votes
1 answer

Determine length in bytes of CLOB/NCLOB with multibyte charset

I'm working with an Oracle database and want to determine the length in bytes of a NCLOB using a multibyte charset (UTF-8). LENGTHB() does not support CLOBs oder NCLOBS with multibyte charset. I could convert the NCLOB to a BLOB and get its length…
Dave
  • 43
  • 2
  • 6
3
votes
0 answers

Oracle OCI determine if field is NCLOB or CLOB

I am looking for a simple way to determine if a field in Oracle is an NCLOB. When I perform an Attribute Get on the field, I always get back 112 (SQLT_CLOB), regardless of whether or not the field is a CLOB or an NCLOB. Here is a code snippet of…
sse
  • 987
  • 1
  • 11
  • 30
2
votes
1 answer

Oracle nclob fields: remove newline (or carriage return) characters

We have information in an Oracle db of type NCLOB, and I want to remove newline characters. This, for example, does not work: MyNclobCell := REPLACE(MyNclobCell, '\n', ''); Do I have an answer below? Yes, yes I do!
MrBoJangles
  • 12,127
  • 17
  • 61
  • 79
2
votes
1 answer

Oracle 11g handling newlines differently than 10g

We have a web service (closed source) that accesses an Oracle 11g database. It was recently upgraded from 10g to 11g. It returns records, one of the columns being an NCLOB type. The string sent to the webservice may contain Windows NewLines, \r\n.…
Stealth Rabbi
  • 10,156
  • 22
  • 100
  • 176
2
votes
0 answers

ORA-65502: cannot access temporary LOB data

I am working on Java+Spring+Oracle application. I am trying to add a new function on the database that stores NClob in a custom type. I ran into the error ORA-65502: cannot access temporary LOB data but I am not sure how to fix my issue. Please…
user2526586
  • 972
  • 2
  • 12
  • 27
2
votes
2 answers

Oracle Select where NCLOB is Like some string

I have an Oracle table, and in this table I have a column of type NCLOB. I would like to perform a SELECT LIKE on it like so: SELECT * FROM T_WEB_TASK_IT WHERE DBMS_LOB.substr( T_WEB_TASK_IT.ISSUE_DESCRIPTION , 32000, 1) LIKE '%Turning on the%' But…
J86
  • 14,345
  • 47
  • 130
  • 228
2
votes
2 answers

UTF-8 - I don't understand this byte sequence

I have a data provider that send me some data supposed to be coded with UTF-8. This data presents this sequence of bytes: 28 49 4e 54 e2 80 99 4c 29 20 (INT’L) => "(INT’L)" For some reason when my java program fetch this data and store it in the…
Stephan
  • 41,764
  • 65
  • 238
  • 329
2
votes
1 answer

pypy ships with cx_Oracle 5.0.0 I need 5.1.2

Accepted answer to this question How to install/use cx_Oracle in PyPy says that in order to install cx_Oracle on pypy I need to compile it with --withmod-oracle parameter. If I do so I'm getting cx_Oracle v. 5.0.0: Python 2.7.3…
mnowotka
  • 16,430
  • 18
  • 88
  • 134
1
vote
2 answers

How to get NCLOB XML data from Oracle database

We use a Java-based application to deploy XML files, which are written to an Oracle database. The XML blobs in the db are stored as NCLOB data types. How would I go about getting the NCLOB XML data from the database and back into XML format? Would…
Keith
  • 1,959
  • 10
  • 35
  • 46
1
vote
1 answer

Oracle Parsing XML returns blank

I have an NCLOB column on my database which has a structure like this: Genotypes <------------------ I DON'T want to get this ... …
dokgu
  • 4,957
  • 3
  • 39
  • 77
1
vote
0 answers

What is the Oracle NCLOB datatype max character length?

I added NCLOB column to table: ALTER TABLE table_name ADD(column_name NCLOB); And I tried insert large text to this column which length is equal 22000. But I get "Too long value" error. What is the maximum length of NCLOB? (I use Oracle 11g)
vaqifrv
  • 754
  • 1
  • 6
  • 20
1
vote
0 answers

Special characters in Oracle NCLOB

I'm dealing with an Oracle 10g database and the following stored procedure is provided: procedure get_synopsis ( p_id in my_schema.products.p_id%type, p_synopses out sys_refcursor); -- cursor of - synopsis_type, synopsis_text In my Java…
Gabe
  • 5,997
  • 5
  • 46
  • 92
1
vote
1 answer

turkish char comes as numerical code after oracle select of nclob field

I have an NCLOB field in the database, which I use to save data created using the fck editor. Certain Turkish characters are displayed as numerical codes after doing an Oracle select from this NCLOB field . For example: the Ç character becomes…
İnan KARACAN
  • 11
  • 2
1
2 3