Clob Handling

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:

<%[email protected]%>

=>

peter xxx 69771704222 alone whatever bicycle motogp cd1
Luxembourg Luxembourg FR ES 5372826865 [email protected] 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

Hi Paulo,

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

On Sep 21, 5:37 pm, Paulo C. [email protected]

I solved my problem.
Thanks

lianliming wrote:

Hi Paulo,

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

On Sep 21, 5:37 pm, Paulo C. [email protected]