Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Clobs in Oracle 10

 
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
Pie
Posts: 50258
79
  • 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: 34973
379
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic