I've put LOV on the left hand side but when i choose some of them, and click on creat, it tells me shuttle must have some value, i searched alot on solving this but i couldn't find, it was working so good but now it doesn't.
here's pictures showing the details of the shuttle.
and here's the process
declare
tab apex_application_global.vc_arr2;
begin
tab := apex_util.string_to_table (:P2_RC);
for i in 1..tab.count loop
insert into STR_RC(STRID, RCID)
values
(:HIDDEN_STR_1, tab(i) );
end loop;
end;
HIDDEN_STR_1 is and ID number from another table.
when i press creat, nothing happen to the table i want to insert data in which is STR_RC, and when i change the process to this code,and change the validation to no, it insert nulls in both columns , so please help .
BEGIN
INSERT INTO STR_RC(STRID,RCID)
VALUES (:HIDDEN_STR_1 ,:P2_RC);
END;
I found the answer, the problem wasn't in my shuttle, the problem was in the sequence of processes.
I have reset process which clear session, and have it before my process that shuttle depend on, so i was getting null all the time.