I have two issues in my application Interactive Report APEX 4.2.5. I have seen some examples of this functionality, but they have not helped me yet.
1 – In the SELECT statement of the report, some fields are selected with apex_item.text so that the user can update these fields. This part works well. My problem is writing back the updated values to a table (SELECT is in a view). I have a SQL Autonomous Block process that should do this (loop through the rows and access values with APEX_APPLICATION.G_Fxx), but it will not work. After sending, no errors are returned. Instead, the values are reset to their original values. How can I save these updates in the table?
2 – Within the SQL process I have activated and added some APEX_DEBUG.MESSAGE statements, but I can not see the result of these statements anywhere in the debug log or in the table. How can I see the result of these debug commands?
Here is the SELECT:
, apex_item.hidden (50, REQUISITION_LINE_ID, 10,10) rid
apex_item.text (10, SUPPLY_PO_NUMBER, 10, 10) SUPPLY_PO_NUMBER
apex_item.text (20, SUPPLY_PO_LINE, 10, 10) SUPPLY_PO_LINE
, apex_item.text (30, SUPPLY_PO_SHIPMENT, 10, 10) SUPPLY_PO_SHIPMENT
And here is the SQL process:
APEX_DEBUG.ENABLE (p_level => 9);
for i in 1..APEX_APPLICATION.G_F50.count
id: = APEX_APPLICATION.G_F50 (i);
poorder: = APEX_APPLICATION.G_F10 (i);
poline: = APEX_APPLICATION.G_F20 (i);
poshipment: = APEX_APPLICATION.G_F30 (i);
APEX_DEBUG_MESSAGE.LOG_MESSAGE (& # 39; ID is & # 39; || id || & # 39 ;, PO is & # 39 ;| poorder || & # 39 ;, SUPPLY_PO_LINE is & # 39; s & nbsp; poline || & # 39 ;, SUPPLY_PO_SHIPMENT is & # 39;; poshipment);
APEX_DEBUG.MESSAGE (ID ID is # || id ||,, PO is | || poorder ||,, SUPPLY_PO_LINE is pol || poline || & # 39 ;, SUPPLY_PO_SHIPMENT is & # 39;; poshipment);
set ATTRIBUTE1 = poorder,
ATTRIBUTE2 = poline,
ATTRIBUTE3 = shipping
where requisition_line_id = id;