# CLOB handling

**URL:** <https://rubytalk.org/t/clob-handling/40811>\
**Category:** ruby-talk\
**Created:** [21 September 2007 09:39 UTC](https://rubytalk.org/t/clob-handling/40811 "2007-09-21T09:39:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Paulo\_Carvalho](https://avatars.discourse-cdn.com/v4/letter/p/a698b9/32.png) [@Paulo\_Carvalho](https://rubytalk.org/u/Paulo_Carvalho)\
**Post date:** [21 September 2007 09:39 UTC](https://rubytalk.org/t/clob-handling/40811/1 "2007-09-21T09:39:56Z")

</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:

\<td class="tform\_rubrique\_value\_cons"\>\<%=@demand.vxml%\>\</td\>

=\>

&nbsp;&nbsp;peter xxx 69771704222 alone whatever bicycle motogp cd1  
Luxembourg Luxembourg FR ES 5372826865 [h@gmail.com](mailto:h@gmail.com) 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

> **···**
>
> --  
> Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/).

---

<div class="post-metadata">

**Author:** ![Paulo\_Carvalho](https://avatars.discourse-cdn.com/v4/letter/p/a698b9/32.png) [@Paulo\_Carvalho](https://rubytalk.org/u/Paulo_Carvalho)\
**Post date:** [21 September 2007 10:04 UTC](https://rubytalk.org/t/clob-handling/40811/2 "2007-09-21T10:04:09Z")

</div>

I solved my problem.  
Thanks

> **···**
>
> --  
> Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/).

---

<div class="post-metadata">

**Author:** ![Jazzy\_Buddy](https://avatars.discourse-cdn.com/v4/letter/j/dc4da7/32.png) [@Jazzy\_Buddy](https://rubytalk.org/u/Jazzy_Buddy)\
**Post date:** [16 April 2008 10:42 UTC](https://rubytalk.org/t/clob-handling/40811/3 "2008-04-16T10:42:14Z")

</div>

Paulo Carvalho 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 ... 🙂

> **···**
>
> --  
> Posted via [http://www.ruby-forum.com/\](http://www.ruby-forum.com/%5C).