I'm using the online instance on apex.oracle.com.
I'm trying to create "Remove" links in a report. Here's the steps I've taken to establish this:
1. Alter the query to add a static column "REMOVE".
2. Create a hidden page item P4_REM_ROWID
3. In Column Attributes, making the REMOVE column into a column link, Target: Page in this Application, Page: 4 (same page), Request: REMOVE, Item1: P4_REM_ROWID, Value1: #ROWID#, and accepting default values for others.
4. Creating a Process: On Load - Before Header, Run Process: Once per page visit. Condition Type: Request = Expression 1, Expresson 1: REMOVE
With the following PL/SQL:
BEGIN
DELETE FROM my_table WHERE rowid = :P4_REM_ROWID;
END;
When I click a remove link in the report, I will not get an error, but nothing will be removed either.
I have found that the reason that it's not working, is because the item :P4_REM_ROWID will actually have the value NULL when the code is run.
Does anyone know where this is flawed?