Take a look at the "execute plsql block" true action of a dynamic action, and at the "page items to submit" and "page items to return" items available in that true action. Clicking help on those will help.
Remember that PLSQL is ran serverside.
Of course! Thanks a lot, Tom.
I think I used this in the past but forgot about the possibilities.
Truly effortless ajax, gotta love it!