ODBC Oracle returning garbage from APSInfo_Objects table

[MJRBIM]

I am running a Crystal Report against the APSInfbjects table of a Crystal Enterprise 8.5 APS (Database for the APS is Oracle 8).

Instead of getting an "Object Name" string in the field OBJNAME, I get an alphanumeric string of garbage like this "4300720079007300740061006c0045006e00740065007200700072006900730065002e004600610076006f0072006900740065007300460
06f006c006400650072000000".

I don't have direct access to the Oracle source data through PL/SQL, so I can't see how it's stored. In MS-SQL it's a string and would show the text in this field.

Any suggestions would be appreciated, thanks in adavance.

 

[synapsevampire]

Are you using the CR supplied ODBC driver? Tried using native connectivity?

If you have MS-Access, try *linking* to the table from there to explore the data, or download the freebie version of Toad.

http://www.quest.com

-k

 

[MJRBIM]

Accessed the data source via SQL*Plus - looks like the Oracle database stores it as a BLOB.

I'm going to talk to the Oracle DBA...

Thanks for the suggestion.

 

[MJRBIM]

According to the DBA...Oracle is storing it as a RAW(255) - in MS-SQL it stores it as a STRING(255).

Guess I'll need to see if there is a way for Crystal to translate a RAW field.