DECLARE URL_PRELAST_PARAMETER_VALUE VARCHAR( 50 );
	DECLARE URL_PRELAST_PARAMETER_POSITION INT;
***************************************************************************
-- Следующий запрос необходимо вызывать динамически, где вместо 
-- URL_PRELAST_PARAMETER_POSITION подставляется  значение переменной.
	SELECT t.* INTO URL_PRELAST_PARAMETER_VALUE 
		FROM DASUSR1.ADDRESS_LOG i, 
		XMLTABLE('$c/address_post_form' passing i.ADDRESS_POST as "c" columns dom varchar( 100 )
		path 'parameter[@id=URL_PRELAST_PARAMETER_POSITION]') as t 
		WHERE i.POST_ID = USEQ;

CREATE PROCEDURE TECHNOLUX_INIT(IN USEQ INT, out URL_PRELAST_PARAMETER VARCHAR( 50 ))
LANGUAGE SQL
DYNAMIC RESULT SETS  1 
BEGIN ATOMIC
	-- ДИНАМИЧЕСКИЙ ЗАПРОС
	DECLARE STMT VARCHAR( 4096 );
	-- ПОСЛЕДНИЙ ПАРАМЕТР
	DECLARE URL_LAST_PARAMETER_VALUE VARCHAR( 50 ) DEFAULT '';
	-- ПРЕДПОСЛЕДНИЙ ПАРАМЕТР
	DECLARE URL_PRELAST_PARAMETER_VALUE VARCHAR( 50 );
	DECLARE URL_PRELAST_PARAMETER_POSITION INT;
	-- КОЛИЧЕСТВО ПАРАМЕТРОВ
	DECLARE URL_PARAMETERS_COUNT INT;
	
	-- Определить курсор
	DECLARE C1 CURSOR WITH RETURN FOR S1;
		
	DECLARE RC_E INT; -- Ошибка
	DECLARE STMT_E VARCHAR( 4096 ); --ошибка
	DECLARE SQLCODE INT default  0 ; -- SQLCODE ошибки
	DECLARE UNDO handler for sqlexception
		BEGIN
			SET RC_E=SQLCODE;
			INSERT INTO DASUSR1.ERROR_LOG VALUES (DATE(CURRENT DATE), TIME(CURRENT TIME), RC_E, STMT_E);
		END;

	SELECT t.* INTO URL_PARAMETERS_COUNT from DASUSR1.ADDRESS_LOG i, xmltable('$c/address_post_form' passing i.ADDRESS_POST as "c" columns UPC INT path 'parameters') as t WHERE i.POST_ID = USEQ;
	
	SET	STMT = 'SELECT t.* INTO URL_LAST_PARAMETER_VALUE from DASUSR1.ADDRESS_LOG i, xmltable("$c/address_post_form" passing i.ADDRESS_POST as "c" columns dom varchar(100) path "parameter[@id=?]") as t WHERE i.POST_ID = '||USEQ;
	PREPARE S1 FROM STMT;
	OPEN C1 USING URL_PARAMETERS_COUNT;
	SET URL_PRELAST_PARAMETER_POSITION = URL_PARAMETERS_COUNT -  1 ;
	SELECT t.* INTO URL_PRELAST_PARAMETER_VALUE from DASUSR1.ADDRESS_LOG i, xmltable('$c/address_post_form' passing i.ADDRESS_POST as "c" columns dom varchar( 100 ) path 'parameter[@id=URL_PRELAST_PARAMETER_POSITION]') as t WHERE i.POST_ID = USEQ;
	
	SET URL_PRELAST_PARAMETER = URL_LAST_PARAMETER_VALUE;
END@

SELECT i.POST_ID, t.* 
from DASUSR1.ADDRESS_LOG i, 
xmltable('$c/address_post_form' passing i.ADDRESS_POST as "c" 
columns dom varchar( 100 ) path 'url_parameter[@id=2]') as t 
WHERE i.POST_ID =  23 @