• 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: 49849
70
  • 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: 34863
369
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