Oracle 11 CLOB datatype using Crystal 10

[SPBarran]

Is there a way to use Crystal's native drag and drop functionality with CLOB data?

We are beginning an upgrade to a newer version of software our company uses. The upgraded software will store the data in xml Clobs. Much of the original datastructure will remain the same but our custom fields are no longer individual fields in the Oracle database. We have at least 100 reports that will need to rewritten. None of our current reports use Crystal Command and we are trying to avoid having to convert them all that way. Is there a way to retrieve the Clob data with formulas or any other way I'm missing? Is there an upgraded Crystal version that does handle Clob data?

Your help is much appreciated!

 

[hilfy]

There is no easy way to parse data out of XML in a CLOB field. You can either parse it in formulas using InStr() to find the tags and Mid() to get the data or you can create stored procedures in Oracle using the Oracle XML handling functions to parse the data and return both the regular fields and the fields from the XML as a cursor that Crystal will read as a table.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.