External Table Processor
The External Table Processor [ETP] plugin is a Process type plugin that allows APEX to use a predefined EXTERNAL TABLE to process a “File Browse..” Item.
The plugin does the following:
- obtains a lock for the given EXTERNAL TABLE
- copies data from WWV_FLOW_FILES to disk.
- ALTER the EXTERNAL TABLE to point to the new file
- Parses, binds, and runs the PL/SQL code.
- removes files from WWV_FLOW_FILES and/or file system
- releases lock on COMMIT/ROLLBACK;
Plugin from: Michael Kutz