aspose file tools*
The moose likes Oracle/OAS and the fly likes Clobs in Oracle 10 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Clobs in Oracle 10" Watch "Clobs in Oracle 10" New topic
Author

Clobs in Oracle 10

Dan Silva
Ranch Hand

Joined: Sep 05, 2007
Posts: 86
I was using our data layer and found that even if I'm using a clob, it wouldn't accept string with over 4000 characters. Is this true? Do I need to use 'bind variables' in order to have anything over 4000 chars?
Thanks
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 36579
    
  16
Don't know much about this, but please check what sorts of CLOB there are. Some DBMSs have different sizes of CLOB.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29287
    
140

Dan,
A CLOB can hold way more than 4000 characters. You do need bind variables though. The command line tool can't take really long strings.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Clobs in Oracle 10
 
Similar Threads
Michael Ernest's 4000th message!!!
Jim�s 3000 posts
Large data entry issue
What happens when the length of the text exceed the limit of the column VARCHAR
Conversion into SQL Result Clob from a String