3 ms·
Neat. Every Oracle shop from 2001 onward has tons of these jobs. Some of the funkiest apps were ones that used it as a deferred task queue as, IIRC, submitting
by koolba 5y ago
Neat. Every Oracle shop from 2001 onward has tons of these jobs. Some of the funkiest apps were ones that used it as a deferred task queue as, IIRC, submitting a job was done transactionally with the rest of your unit of work.
If you think DBMS_JOB is great, then you’ll love UTL_TCP! What better way to build an unsupportable nightmare than arbitrary TCP sockets directly from PL/SQL stored procedures: https://docs.oracle.com/cd/E18283_01/appdev.112/e16760/u_tcp.htm https://docs.oracle.com/cd/E18283_01/appdev.112/e16760/u_tcp...
- orf 5y agoOh my god
- ThePadawan 5y agoIt really makes you wonder what happened in the last 40 (?) years that we went from Customer: "Do you sell software that does <random shit>?" Software company: "Yeah sure, it's part of <giant software suite>! You only need to upgrade to the newest version for $50k!" to Customer: "Do you sell software that does <random shit>?" Software company: "Yeah sure, it's our new completely separate product! It's only $50k!"
- avi_vallarapu 5y agoYa, especially when there exists PostgreSQL like Open Source databases that includes Native Partitioning, Replication, Full Backups plus Point in time recovery, Read Replicas, too many data types including boolean, uuid like types that are not possible with Oracle.