Oracle APEX 24.1.7 (against Autonomous database 23ai)
Would like advice how to debug a button and its Processing.
I have been working with APEX for a while. I have an existing application in development where buttons created a while ago work fine - Processing / Dynamic Actions
If I Duplicate or create new Buttons, I cannot get either Processing / Dynamic Actions to work.
My actual use-case is allowing user to press a button and call plsql - existing buttons work fine. Just need some new buttons to call some more plsql … should be easy.
I suspect one of
- I am missing something obvious
- APEX functionality has changed (recently)
- I have lost my marbles :)
Basic questions:
- a) Should I be able to use dbms_output to print to APEX (in debug mode)?
- b) Should I be able to use plsql to set an APEX item's value (and have it displayed) ?
A simple testcase + debug confuses me more :(
The page is simple - one button + one item:
The Process is simple - plsql block :
Debug of this session:
NB debug says P6_ROWCOUNT item is varchar2 but it is a number field:
Worse, the plsql block in debug is not same as in APEX
Any ideas what might be going on ?