Submitted by: Viktor Belzetskiy (viktor_bs)

No check dependence return fields in udr-procedures

example:
-----------------------------------------------------------------
CREATE PROCEDURE TEST_UDR_PROC
RETURNS (
NUMBER DOUBLE PRECISION)
EXTERNAL NAME 'udr_vds!fstrOpenAnyTable' -- any udr-procedure
ENGINE UDR;

CREATE PROCEDURE TEST_PROCEDURE
RETURNS (
NUMBER DOUBLE PRECISION)
AS
BEGIN
FOR
SELECT NUMBER
FROM TEST_UDR_PROC
INTO :NUMBER
DO
SUSPEND;

END;

ALTER PROCEDURE TEST_UDR_PROC
RETURNS (
NUMBER_2 DOUBLE PRECISION) -- !!! change field name !!!
EXTERNAL NAME 'udr_vds!fstrOpenAnyTable'
ENGINE UDR;

Successfull. No error !!!