Hello everyone,
I've been trying to solve my problem for a few days but I struggle to identify the source of the problem since I'm new with APEX and sql coding.
Here is my problem :
I have a page with multiple select lists, text fiel, radio group… My page is of type form.
I have a button called Validate that reacts when clicked and that has a dynamic action : action → execute server-side code / Language → PL/SQL and this is the code I use :
UPDATE GPN_GPN
SET
LABELINGSC = null,
UTILIZATION = :UTILIZATION,
SOURCE = :SOURCE,
TECHNICALRANGE = :TECHNICAL_RANGE,
ETNCODE = :ETN_OTHERS,
ACIDVOLUME = :ACID_VOLUME,
--....(assigning page items to databse columns)...
WHERE GPN = :P3_GPN_DISPLAY;
commit;
P3_GPN_DISPLAY is a page item of type display only that has the value of a concatenation of two page items coming from page 2. Regarding of the two values I choose in page 2 (which is a page of type form containing two dynamic select lists), I click on a button called next that execute an sql insert statement of the concatenation of those two values into the column GPN of my table GPN_GPN and then I display the value inserted at the top of page 3 from my page item P3_GPN_DISPLAY (no issue so far, neither on the insertion of the values or the display).
The problem is, when I click on the button validate in page 3, the values are not updated into my table. The query is not the issue because I have tried with static values ( WHERE GPN = ‘test’ ) and it works fine.
Do you have any idea on how I could make this work ?
best regards,
David