# CLOB handling

**URL:** <https://www.ruby-forum.com/t/clob-handling/115178>\
**Category:** Ruby\
**Created:** [September 21, 2007, 11:39am UTC](https://www.ruby-forum.com/t/clob-handling/115178 "2007-09-21T11:39:55Z")\
**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:39am UTC](https://www.ruby-forum.com/t/clob-handling/115178/1 "2007-09-21T11:39:55Z")

</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, 12:04pm UTC](https://www.ruby-forum.com/t/clob-handling/115178/2 "2007-09-21T12:04:08Z")

</div>

I solved my problem.  
Thanks

---

<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:** [April 16, 2008, 12:42pm UTC](https://www.ruby-forum.com/t/clob-handling/115178/3 "2008-04-16T12:42:12Z")

</div>

Paulo C. wrote:

> I solved my problem.  
> Thanks

Please can u post the solution for ur ptroblem as we are facing a  
simiklar kind of issue here.

Regards,  
Jazzy … 🙂