[Info-ingres] Fridays comedy error message: E_US0876 SELECT: line 1, procedure 'burst_dms' in FROM clause must be row producing

[Adrian Williamson]

Hi,

The following stripped down script gives a E_US0876 error in the final procedure declaration.
 
What we worked out eventually after a recursive process of reduction was that the 'or replace' syntax in the last procedure definition was responsible for the error.

This was on: II 10.2.0 (su9.us5/100) Patch 15134.

Not very helpful that.

I've raised a bug.

Cheers

Adrian


CREATE PROCEDURE burst_dms ( IN dms varchar(111) NOT NULL )
RESULT ROW soundexes ( soundex char(6) NOT NULL )
AS
DECLARE soundex char(6) NOT NULL;
BEGIN
    RETURN ROW (soundex);
END;\p\g

create table name_sounds (
	soundex char(6) NOT NULL,
              no char(9) NOT NULL NOT DEFAULT,
	dob date NOT NULL,
	first_initial char(1) NOT NULL
);\p\g

CREATE or replace PROCEDURE name_sounds  AS
BEGIN

    INSERT INTO name_sounds ( soundex,no,dob,first_initial )
    SELECT dms.soundex, '666', '1-1-70', 'A'
    FROM burst_dms(soundex_dm('WILLIAMSON')) dms;
    
END;\p\g