• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Clobs in Oracle 10

 
Dan Silva
Ranch Hand
Posts: 86
  • 0
  • 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
Pie
Posts: 47229
52
  • 0
  • 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
Marshal
Posts: 33684
316
Eclipse IDE Java VI Editor
  • 0
  • 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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic