# What's the trick for using CLOB values (Oracle)?

**URL:** <https://www.ruby-forum.com/t/whats-the-trick-for-using-clob-values-oracle/108645>\
**Category:** Rails\
**Created:** [July 5, 2007, 4:53pm UTC](https://www.ruby-forum.com/t/whats-the-trick-for-using-clob-values-oracle/108645 "2007-07-05T16:53:31Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![dmorin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/f0a364/32.png) [@dmorin](https://www.ruby-forum.com/u/dmorin)\
**Post date:** [July 5, 2007, 4:53pm UTC](https://www.ruby-forum.com/t/whats-the-trick-for-using-clob-values-oracle/108645/1 "2007-07-05T16:53:31Z")

</div>

I’ve got a bunch of fairly large values (30kb each) I’m trying to insert  
into a CLOB column in my Oracle(10g) model. Since Rails is trying to  
create a typical insert statement with the entire value, this is causing  
a problem. Is there a trick I need to know to make this work, or am I  
out of luck?

Thanks!