File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Clobs in Oracle 10
Joined: Sep 05, 2007
May 14, 2008 08:24:00
I was using our data layer and found that even if I'm using a clob, it wouldn't accept
with over 4000 characters. Is this true? Do I need to use 'bind variables' in order to have anything over 4000 chars?
Joined: Oct 13, 2005
May 14, 2008 09:18:00
Don't know much about this, but please check what sorts of CLOB there are. Some DBMSs have different sizes of CLOB.
Joined: May 26, 2003
May 14, 2008 18:28:00
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.
How To Ask Questions The Smart Way
Blogging on Certs:
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
I agree. Here's the link:
subject: Clobs in Oracle 10
Conversion into SQL Result Clob from a String
Large data entry issue
Jim�s 3000 posts
Michael Ernest's 4000th message!!!
What happens when the length of the text exceed the limit of the column VARCHAR
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014