Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Insert process APEX

Pav1May 13 2020 — edited May 30 2020

I created stacked master detail page with two table.

And new region with shuttle item, and button.

DECLARE

    vTAB APEX_APPLICATION_GLOBAL.VC_ARR2;

BEGIN

vTAB := apex_util.string_to_table (:P2_SHUTTLE);

FOR i IN 1 .. vTAB.count LOOP

        INSERT INTO table_name (fk_column2_id, fk_column_id)

        VALUES (vTAB(i), :P2_LOV);

    END LOOP;                                                           

END;

when I select column_id in master table and try insert I get cannot insert null into fk_column_id.

All works fine if I set number instead :P2_LOV, but it insert always for same id

Comments
Post Details
Added on May 13 2020
5 comments
766 views