Home » SQL & PL/SQL » SQL & PL/SQL » problem with storing large data in nclob (9i)
problem with storing large data in nclob [message #322273] Thu, 22 May 2008 23:50 Go to next message
Messages: 16
Registered: November 2006
Location: hyderabad
Junior Member
Dear experts,

As per the documents, we can store 4GB of data in nclob data type. But it allows only 4000 bytes while i am trying to insert more than that, its throws an error message "string literal too long".

Please help me. Thanks in Advance.
Re: problem with storing large data in nclob [message #322286 is a reply to message #322273] Fri, 23 May 2008 00:25 Go to previous message
Michel Cadot
Messages: 63924
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
String literal limit.
No relation with column limit.

Previous Topic: Global Temp Tables and PL/SQL
Next Topic: Missing Symbol while loading external library
Goto Forum:

Current Time: Wed Oct 26 02:39:08 CDT 2016

Total time taken to generate the page: 0.08553 seconds