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>


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 7882
Received on Fri Jul 17 1992 - 16:12:51 CEST

Original text of this message