APEX

I have read it: http://apex.oracle.com/pls/otn/f?p=35253:1:2820687553996558::NO but I don't understand shuttle.

My shuttle name is 'P3_SHUTTLE'. I have created shuttle by clicking (Create Item -> Shuttle -> next -> etc.). In first part of shuttle I have all elements from some table in database. In second part of shuttle I have choiced elements from first part of shuttle (as in each normal simply shuttle). I would like insert elements from second part of shuttle when somebody clicked button (which I have created). I have created process for this button type PL/SQL anonymous block. In field source of this process I have written:

DECLARE
BEGIN
FOR z in 1..htmldb_application.g_f02.count loop
INSERT INTO books(id_book) VALUES(htmldb_application.g_f02(z));
END LOOP;
END;

but it doesn't work (I don't know what is 'htmldb_application.g_f02.count' - it was in yours example).


So I have tried:

DECLARE
BEGIN
FOR z in 1..P3_SHUTTLE.pSQL_2.count loop
INSERT INTO books(id_book) VALUES(P3_AKTORZY.pSQL_2(z));
END LOOP;
END;

P3_SHUTTLE it is name of my shuttle

but this code also doesn't work :( HELP please :(

Edited by: user10728391 on 2008-12-19 01:17

Edited by: user10728391 on 2008-12-19 01:18