Run PL/SQL in the background and display a progress bar


Running a long process from APEX application will force the browser to hang and the web server to send a timeout error. Here how you can run such a process.

Run PL/SQL in the background and display a progress bar


Comments

Post a Comment

Popular posts from this blog

PDF Viewer in APEX

For a long time I was struggling with  having to use a JS library ( https://bashooka.com/coding/10-javascript-libraries-and-tools-to-work-with-pdf/ ) to view pdfs or images from the database, but with no luck because my files are stored in the database as BLOBs, it may seem simple for someone, but was not obvious for me to have a URL for my BLOBs to server the JS libraries. The following post will show how this is done. Preview PDF Uploads in an APEX App (Cross-post)
Read more

Tom behind asktom.oracle.com talking about mod_plsql history

Here is the history..... in the beginning there was this thing called the "WOW gateway" (Web Oracle Web).   It was a cgi-bin that crudely translated a url into a stored procedure call (didn't use bind variables!!! that is why I call it "crude")....   It was written originally by Magnus Lonnroth of Sweeden. This became OWA (Oracle Web Agent) in version 1 of OIS (the Oracle Internet Server).   It too was a cgi-bin. Later, with version 2 of OWS (OIS -> OWS, the Oracle Web Server), this OWA became a "cartridge" in OWS speak.   Like a module for apache but ran in the spyglass mosaic webserver (which is what we used). At that time, some guy named -- oh wait, that was me -- wrote this thing called OWAREPL (historically archived here: http://asktom.oracle.com/~tkyte/owarepl/doc/ ).   It greatly extended the capabilities of OWA giving it file upload/download, db authentication and many of the features you take for grant
Read more

APEX with Reverse Proxies.

For production installation, you surely need to have a layer in front (Reverse Proxy) of your ORDS, here are samples of configuration for the most popular web servers 1. Apache      Reverse Proxy Configuration using Apache 2. NGINX     The Oracle APEX Reverse Proxy Guide using NGINX
Read more