Hi guys, I hope someone can help me with this problem:
I knew we normally use Automatic Row Processing and set the "Return key into item" attribute to the hidden item, but I did some processing before the insert process so i want to do the insert operation manually:
declare
l_id number;
begin
/* do some things here */
insert into table_name(col_1, col_2) values(val_1, val_2) returning id into l_id;
:P1_HIDDEN_ITEM := l_id;
end;
I tried to set the hidden item with the most recent item's ID as described in the code above, but it just doesn't work ... please let me know if you have better solution for this. Thanks!
P.S. I am using Apex v5.0.4