Pro*Cobol Problem 02
Date: 10 Nov 93 20:57:00 GMT
Message-ID: <2456.208.uupcb_at_digitec.co.za>
Continued from the previous message...
..
END;
END-EXEC.
C2100-EXIT.
EXIT.
D0000-CLOSE SECTION.
D1000-PARA.
CLOSE PRINT-FILE.
D0000-EXIT.
EXIT.
I-ERROR SECTION.
I-PARA.
DISPLAY "***** A SQL ERROR OCCURRED IN OAZR0015 ****".
STOP RUN.
I-EXIT.
EXIT.
Description of Problem
When the program is executed *without* the Reference Line 1 (Initialize), it generates an error 'ORA1488: NIBBLEBYTE PROBLEM' on Reference Line 2. When it is executed *with* the Reference Line 1, it generates an error 'ORA1457: CONVERSION COLUMN OVERFLOWS DECIMAL DATATYPE'. There seems to be no way to successfully execute this program.
The program uses the standard Oracle demo PRICE table. It runs on Oracle 6 under Unix. This is actually a test program. We encountered the problem in a large critical production program.
Could anyone help please !
- Greetings. Dewald Pretorius Fax: +27-11-3135122
- Internet: dewald.pretorius_at_digitec.co.za Tel: +27-11-3135227
- RM 1.2 * Eval Day 25 * CURSOR: What you become when your system crashes.
- Digitec Online - 10 Nodes - Johannesburg - South Africa - +27-11-476-7136 -
- _at_digitec.co.za - ILink - Weather - BASNet - RsaNet - Fidonet -