Retreive nested tables from oracle

[ajdesigns]

Hi
can I retrieve nested tables including CLOB's from an Oracle D/B in Crystal X1. I will be upgrading from CR 8.5 To CR X1 soon and wanted to know if X1 had this capability (I know 8.5 does not). I am currently writing my reports from the oracle D/B in Oracle reports but I would prefere to use Crystal if this is possible.

 

[synapsevampire]

Not sure, but if the ODBC driver doesn't support accessing them directly, than I doubt it.

From an external application you could using JDBC.

As for from within Crystal itself, you might consider creating SP's as the data source to accomplish this.

-k