You could transfer the PL/SQL part in you DA to an "on demand process"and trigger that process from the java (jquery) part in your DA.
this would look something like this:
var lRequest = new htmldb_Get(null, $v('pFlowId'), 'APPLICATION_PROCESS=BUILD_ANYCHART_XML_PROCESS', $v('pFlowStepId'));
+If the question is answered please change it to answered and mark the appropriate post as correct/helpfull.+
Thanks. But on-demand processing makes thing a bit less transparent - the Apex app needs to be managed from a developer perspective by guys from our product management team and I want to make it as easy to understand as possible. Which I believe my current attempt is.
I've tried a CSS approach. Goes something like this: document.body.className='waiting';doAction();document.body.className=''; - where "waiting" sets the document cursor to waiting.
You could try the built-in wait popup usually used for on-submit loading indicator:
There is no removal method for it though but it is fairly straightforward and easy enough as it's plain html
Thanks. Still does not work.
The wait effect (popup, wait cursor, etc) does not render - and I've tried a couple of method to provide a visual cue.
It as if the browser's GDI does not get a chance to refresh and display that wait effect, prior to doing the PL/SQL (Ajax) call.
Interesting, it worked for me. Thanks Tom, something new learned.
The only caveat was that when the PSQL executed very quickly, there was a very quick blip and it was gone but that worked for me since I wanted the visual cue only as long as there was a delay.
Weird - that should work. When you run it from the browser's developer tools console - can you see it pop up?
Yes, everything works fine via console when called manually and individually.
Will play around some more with it..