access data from oracle

[ajdesigns]

Hi
Is there any way I can access underlying objects in an oracle db. I am new to oracle but I have tried to write a report in cr 8.5 from an oracle 9i db but some of the fields are not available because I have been told they are tables within a field. The only way we could access this data was by creating a view in the oracle db to Flatten the table and reveal the data in the underlying tables. Is there a way I can use this data without creating the view. The person I was talking to referred to CLOB.

 

[paulmarr]

Hi,

No - Crystal cannot recognise a CLOB field - BLOB yes - CLOB no.

You will need a view over the field containing the tables.

Cheers,
paulmarr