| Insert process ORACLE APEX [message #680412] |
Wed, 13 May 2020 13:10  |
 |
petar97
Messages: 120
Registered: October 2018
|
Senior Member |
|
|
I created stacked master detail page with two table.
And new region with shuttle item, and button.
I created process for shuttle insert
declare
tab apex_application_global.vc_arr2;
begin
tab := apex_util.string_to_table (:P2_NEW);
for i in 1..tab.count loop
insert into privs (fk_priv_id, fk_role_id)
values (tab(i), :ROLE_ID);
end loop;
end;
:P2_NEW - is shuttle
When I select role_id in master table and try to insert data I get error cannot insert null into fk_role_id...
When I replace :ROLE_ID with number(eg. 3) all works fine, but insert always for ROLE_ID 3 not for selected one.
What should I do to insert selected value from master table.
I can make test apex page, If you want to see code
Thanks in advance!
[Edit MC: change table and column names at OP request]
[Updated on: Sat, 04 July 2020 13:42] by Moderator Report message to a moderator |
|
|
|
| Re: Insert process ORACLE APEX [message #681299 is a reply to message #680412] |
Mon, 06 July 2020 06:40  |
|
petar97
Messages: 120
Registered: October 2018
|
Senior Member |
|
|
I solved problem using LOV with shuttle(without master-detail regions)
DECLARE
vTAB APEX_APPLICATION_GLOBAL.VC_ARR2;
BEGIN
vTAB := apex_util.string_to_table (:P2_SHUTTLE);
DELETE FROM privs WHERE fk_role_id = :P2_LOV;
FOR i IN 1 .. vTAB.count LOOP
INSERT INTO privs (fk_priv_id, fk_role_id)
VALUES (vTAB(i), :P2_LOV);
END LOOP;
END;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
