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.
author & internet detective
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.
OCA 8 book
How To Ask Questions The Smart Way
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
subject: Clobs in Oracle 10
Michael Ernest's 4000th message!!!
Conversion into SQL Result Clob from a String
Jim�s 3000 posts
Large data entry issue
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-2015