I use APEX 4.2.3 with XE, i try to insert data in table using code below but nothing happen when i press button, this button create as "create page item button" -> "dynamic action" -> "execute pl/sql"
insert into dummy values('xx');
So to clarify, you've
1) created a button who's 'action' is 'defined by dynamic action'
2) created a dynamic action that executes pl/sql on click of the button, and that's you're pl/sql?