Skip to main content

I have an embedded SQL statement to read a single row that contains varchar data from an Oracle database. My code seems to be correct as I do not get any errors and it runs to success. However the data I am getting back almost looks like it is encrypted. Other data types are correct. It is only the varchar data that is not. My COBOL program is running Server Express 5 on SUSE Linux Enterprise Server 11 (x86_64) but the database is on Windows 2008 Enterprise 32-bit. I am not sure is this has anything to do with the problem.


#COBOLORACLEEXECSQLCOMPILE

I have an embedded SQL statement to read a single row that contains varchar data from an Oracle database. My code seems to be correct as I do not get any errors and it runs to success. However the data I am getting back almost looks like it is encrypted. Other data types are correct. It is only the varchar data that is not. My COBOL program is running Server Express 5 on SUSE Linux Enterprise Server 11 (x86_64) but the database is on Windows 2008 Enterprise 32-bit. I am not sure is this has anything to do with the problem.


#COBOLORACLEEXECSQLCOMPILE

This sounds like it might be a problem with the character sets that are being used in the different environments.

Are you using Oracle Pro*COBOL to precompile your programs or are you using OpenESQL and an ODBC driver?

Does the data look OK if you try to access it directly from the Windows system?

Thanks.

Terms & ConditionsAccessibility statement