I am using CR 8.5 to report data from Oracle 9i. I have a column defined as LONG RAW and is populated with text data from an ERP system. When I use that column in Crystal, it shows it as BLOB datatype and the field is blank. How can I place the text data in a report?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Oracle 9i BLOB / LONG RAW data in report 1
- Thread starter prigro
- Start date
-
1
- #2
synapsevampire
Programmer
Try creating a SQL Expression and convert the field to a varchar, as in:
CAST(table.field as varchar2(1000))
Or use CONVERT.
Keep in mind that Oracle 9 wasn't supported by CR 8.5.
Also, you didn't state what connectivity you're using, you have the option of Native, Cyrstal supplied Oracle ODBC, or Oracle ODBC< don't use Oracle ODBC.
-k
CAST(table.field as varchar2(1000))
Or use CONVERT.
Keep in mind that Oracle 9 wasn't supported by CR 8.5.
Also, you didn't state what connectivity you're using, you have the option of Native, Cyrstal supplied Oracle ODBC, or Oracle ODBC< don't use Oracle ODBC.
-k
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question