Our database has an automated routine which waits for a triggering event and, when this event occurs, it sends a XML document. This side of the entire process already works fine.
But, at the other side, user(s) will stare at the APEX page, waiting for an answer - this process takes some seconds to be completed: some time to send the XML document, and some time to wait for the response. When processing is over, user(s) will want to know about it.
Describing a little bit more about what happens at the database, after pressing an APEX button that sends the XML document: validations are done and, given that everything is correct, an insert is done into another table which is already being updated with current processing/transmitting status (as said before, this works fine). Once finished, this process must update another table, and it's over.
My question is: how can I create a status bar at APEX which displays this progress status from start to finish? Actually I could put another button so user can retrieve status, but I think something more automated will be welcome, even for future developments. Not many details are needed, just some guidelines and some debate will be both welcome. I use APEX 4.2 and I am basically self-taught, so please be patient. Thanks in advance.