Win a copy of Java Concurrency Live Lessons this week in the Threads forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Clobs in Oracle 10  RSS feed

 
Dan Silva
Ranch Hand
Posts: 86
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 53779
128
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Don't know much about this, but please check what sorts of CLOB there are. Some DBMSs have different sizes of CLOB.
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36463
464
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!