APEX

Hi

I have a form with two items : P3_COMMENTAIRES and P3_COMMENT. I want with a dynamic action on a button to concatenate the values of these two fields into the field P3_COMMENTAIRES. For example, if P3_COMMENTAIRES contains the text "FIRST", and the item P3_COMMENT contains the value "SECOND", the item P3_COMMENTAIRES will be assigned the value "FIRST SECOND" when I click on the buton ADD_COMMENT. I have set up a dynamic action but without result.

DECLARE

COMMENTAIRE VARCHAR2(512);

COMMENT VARCHAR2(512) ;

RESULT VARCHAR2(512) ;

BEGIN

COMMENTAIRE := APEX\_UTIL.FETCH\_APP\_ITEM(

    p\_item => 'P3\_COMMENTAIRE',

    p\_app => 112);

COMMENT := APEX\_UTIL.FETCH\_APP\_ITEM(

    p\_item => 'P3\_COMMENT',

    p\_app => 112);

RESULT := COMMENTAIRE || ' ' || COMMENT ;

APEX\_UTIL.SET\_SESSION\_STATE('P3\_COMMENTAIRES', V('RESULT'));

END;

Thank you.