Found my core dump in SQL*Forms!
From: Stephane Hamel <shamel_at_mais.hydro.qc.ca>
Date: 17 Jul 92 14:12:51 GMT
Message-ID: <shamel.711382371_at_tdsb-s>
vcol1 CHAR(15);
vcol2 NUMBER;
BEGIN
OPEN C1;
FETCH C1
INTO vcol1,col2; /* Note: col2 should be vcol2 */ CLOSE C1;
END; When you generate the form, there is no complaint, when you run it, you get a core dump. Even if you comment all call to this procedure you'll get it.
Date: 17 Jul 92 14:12:51 GMT
Message-ID: <shamel.711382371_at_tdsb-s>
I finally found my BIG, HUGE, ENORMOUS problem in a SQL*Forms... and it may be a bug in the form generation. Here is a simplified code abstract:
PROCEDURE update_tassement IS
CURSOR C1 IS
SELECT t1.col1,t1.col2 FROM u1.table1 t1 WHERE t1.col3 = val1;
vcol1 CHAR(15);
vcol2 NUMBER;
BEGIN
OPEN C1;
FETCH C1
INTO vcol1,col2; /* Note: col2 should be vcol2 */ CLOSE C1;
END; When you generate the form, there is no complaint, when you run it, you get a core dump. Even if you comment all call to this procedure you'll get it.
Now, SQL*Forms will complain about the following code:
SELECT t1.col1,t1.col2
INTO vcol1,col2
FROM u1.table1 t1
WHERE t1.col3 = val1;
I run SQL*Forms V3.0.16.5.1 on a SUN 330 SparcStation...
-- Stephane Hamel | AutoControle Inc. SHamel_at_Mais.Hydro.Qc.Ca | Montreal, Quebec, Canada | Phone: 1 514 858 7882Received on Fri Jul 17 1992 - 16:12:51 CEST