CREATE PROCEDURE TEST
RETURNS(
  lcName VARCHAR(40))
AS
BEGIN
   FOR SELECT
      ALU_NOMBRE,
      ALU_APELLD
   FROM
      ALUMNOS
   INTO
      :lcName,
      :lcName
   DO
      SUSPEND;

END;

In the above stored procedure there are 2 columns in the FOR SELECT but
just 1 variable name.

It seems a bug for me. Or there are some reasons for allowing to do such
thing?

Of course, the fault is of the programmer, but it can be detected at
compilation time.

Firebird version: 2.5.5

Greetings.

Walter.
  • ... 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
    • ... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
      • ... 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
        • ... 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
          • ... 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
            • ... Tim Ward t...@telensa.com [firebird-support]
              • ... Marsupilami79 marsupilam...@gmx.de [firebird-support]
              • ... DougC d...@moosemail.net [firebird-support]
                • ... Tim Ward t...@telensa.com [firebird-support]
                • ... 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
                • ... 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]

Reply via email to