Hi,
I am writing a PL/SQL procedure to delete checked rows of my tabular form. My code is:
BEGIN
FOR i in 1..apex_application.g_f02.count LOOP
DELETE FROM PRODUCT_LEVELS
WHERE PARENT_PRODUCT=:P36_PRODUCT_ID AND CHILD_PRODUCT=apex_application.g_f02(i) AND :APEX$ROW_SELECTOR is not null;
COMMIT;
apex_application.g_print_success_message := 'Entry deleted successfully';
END;
Its deleting all my rows when I run the process by clicking on the delete button.
As per the documentation: http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21674/concept_sub.htm, the bind variable holds X if not checked and null when unchecked. So I am not sure where I am going wrong.
Would be grateful if someone could kindly guide me.
Cheers.
Using Apex 4.1.1