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!

problem deleting rows with APEX$ROW_SELECTOR

xarg-XrcOct 21 2012 — edited May 6 2013
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
This post has been answered by Luis Cabral on Oct 22 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 3 2013
Added on Oct 21 2012
11 comments
2,641 views