Manage your job scheduler in APEX

But everything should be done in a fitting and orderly way.1 Corinthians 14:40

Monitoring your scheduler jobs in APEX is not something new. There have been many discussions on how to implement this on various sites. Some of these sites have brilliant and straight forward approach. I encourage you all to visit them: Oracle Scheduled Job APEX Dashboard by Amanda Walsh and DBMS_SCHEDULER examples by Tobias Arnhold.
Continue reading

Storing files in Oracle XE with Oracle Application Express

If you are running Oracle APEX that comes with Oracle XE installation, chances are that you are still making use of Embedded PL/SQL gateway, which essentially uses Oracle XML DB HTTP component. In reality this means that all your files are stored in the database itself.

Simply dragging your files to the /images directory of apex will not have any effect as one would have hoped; frequent changes to your javascript files or images is quite common during development and therefore can be very annoying sometimes.

Continue reading

Access SmartBro Canopy through DD-WRT router

Countless nights in the Philippines behind a laptop trying to figure out how to have stable connection from SmartBro. It was hair pulling experience!

Many have reported that SmartBro was found to be slow, laggy, and not functioning as they expected. There comes the day when the SmartBro connection just goes crappy and slow and another day it is blitzing fast (still not comparable with foreign internet speed).
Continue reading