Hi!
I use LoV item with shuttle. I tried to create save process for shuttle item, but when I move value to right side I got error:
Error computing item source value for page item P8_SHUTTLE. ORA-01722: invalid number
When I click OK button value is inserted. When I move values from right to left side there is no error.
Save process:
DECLARE vTAB APEX_APPLICATION_GLOBAL.VC_ARR2; BEGIN vTAB := apex_util.string_to_table (:P8_SHUTTLE); DELETE FROM role_privileges WHERE fk_role_id = :P8_ROLES; FOR i IN 1 .. vTAB.count LOOP INSERT INTO role_privileges (fk_privilege_id, fk_role_id) VALUES (vTAB(i), :P8_ROLES); END LOOP; END;
Vinish Kapoor
Your process PL/SQL code is ok.
I think the issue is with the source column property. Make sure that you specified the varchar2 field.
pavlos
Problem was in shuttle source, now works well.
Is delete in my save process good or there is better solution?
Vinish Kapoor
In the process, it is completely fine. You can also do this in the DB trigger.