Cobol Runtime Errors in Oracle 8i Migration. 1

[pacopinto]

We are trying to migrate Mims OE from Oracle v 7.3.4 to Oracle 8i (8.1.6) on the RS6000 / AIX 4.3.3 platform.

Everything went fine until we got runtime errors that are apparently related to the way the Micro Focus Object Cobol (v4.1 rev 30) compiled executables are communicating with Oracle.
We get the ORA-1405 error message, which means that a cursor fetch is trying to asssign null values comming from
the database to the host variables in the program. But this
is impossible, since all columns are defined as "NOT NULL", and have a blank (space) character in then if not being used.

We suspect that there is some type of character conversion which strips blanks and leaves null values instead, causing the problem. There are many references in Oracle Documentation to precompiling options that have to be set when precompiling Pro*Cobol with 8i and that are different from previous versions (ie v7), and that resolve these problems.

Does anyone have any experience with this kind of migration? How can I recompile mims executables using this flags?

thanx very much, help will be much appreciated.

PacoPinto

 

[Glen]

When you converted your database, did the default value constraints also convert? These are needed to ensure that the values are blanks instead of nulls.

You may want to bring over the default value constraints before importing the data.
Glen Colbert
gcolbert@RAG_American.com