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
ramora
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: 65087
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
String literal limit.
No relation with column limit.

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


Current Time: Tue Jul 25 10:15:32 CDT 2017

Total time taken to generate the page: 0.10468 seconds