# Clob Handling

**URL:** <https://www.ruby-forum.com/t/clob-handling/196473>\
**Category:** Rails\
**Created:** [September 21, 2007, 11:37am UTC](https://www.ruby-forum.com/t/clob-handling/196473 "2007-09-21T11:37:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![crazybass](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/eb9ed0/32.png) [@crazybass](https://www.ruby-forum.com/u/crazybass)\
**Post date:** [September 21, 2007, 11:37am UTC](https://www.ruby-forum.com/t/clob-handling/196473/1 "2007-09-21T11:37:32Z")

</div>

Hello

In an oracle table, I hava a field of CLOB type (named “VXML”).  
This column have a XML text and i would like to parse it to extract  
several informations.  
In ruby when i access to this column, and for exemple, i put is value on  
a page, I dont have the column in XML format. I only have the values of  
the XML.  
Exemple:

\<%=@demand.vxml%\>

=\>

peter xxx 69771704222 alone whatever bicycle motogp cd1  
Luxembourg Luxembourg FR ES 5372826865 removed\_email\_address@domain.invalid other  
Suzuki 400 775111 Fazer 600 whatever fzs6 Carvalho  
24081004333 fille no yes no

Is there any method to get the column has an XML to parse it and get the  
needed information?

Thanks

regards

---

<div class="post-metadata">

**Author:** ![crazybass](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/eb9ed0/32.png) [@crazybass](https://www.ruby-forum.com/u/crazybass)\
**Post date:** [September 21, 2007, 11:58am UTC](https://www.ruby-forum.com/t/clob-handling/196473/2 "2007-09-21T11:58:20Z")

</div>

Hi Paulo,

You can check the link  
[http://lists.rubyonrails.org/pipermail/rails/2006-March/023178.html](http://lists.rubyonrails.org/pipermail/rails/2006-March/023178.html)  
to find the answer.

On Sep 21, 5:37 pm, Paulo C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![crazybass](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/eb9ed0/32.png) [@crazybass](https://www.ruby-forum.com/u/crazybass)\
**Post date:** [September 21, 2007, 12:04pm UTC](https://www.ruby-forum.com/t/clob-handling/196473/3 "2007-09-21T12:04:32Z")

</div>

I solved my problem.  
Thanks

lianliming wrote:

> Hi Paulo,
> 
> You can check the link  
> [http://lists.rubyonrails.org/pipermail/rails/2006-March/023178.html](http://lists.rubyonrails.org/pipermail/rails/2006-March/023178.html)  
> to find the answer.
> 
> On Sep 21, 5:37 pm, Paulo C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)