Search code examples
oracle-databaseoracle-apexoracle-apex-5

Oracle Apex: Shuttle doesn't put value on the right side and provide null


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.

enter image description here

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;

Solution

  • 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.