APEX-PLUGIN.COM

..the apex plugin directory

an initiative of

Add your APEX Plugin info

Describe your Plugin’s features. You can upload the Plugin’s code and documentation, or, alternatively, submit the URLs to your Website, GitHup Repository or Blog.

You are here:
Follow us on Twitter
Dynamic Action Plugin Enkitec CLOB Load

Enkitec CLOB Load

8
Categories: Dynamic Action Plugin
Author: Dan McGhan

A plug-in for moving large amounts of text data

Have you ever used a Rich Text Editor item type in APEX? Has the amount of text ever exceeded 32k? Choke! And so begins the search for a work around... While work arounds exists they can be a little difficult find and repeat each time you need them. We designed the Enkitec CLOB Load plug-in to simplify and standardize how large amounts of text are moved from the database to APEX page items and then back to the database.

The plug-in has a CLOB Action setting with values tied to the two basic phases involved when working with CLOBs in APEX: render and submit. These are similar to the native render and processing phases in APEX but the timing is a little different. The rendering of CLOBs happens after the APEX page has loaded and the submit of CLOBs happens before the page is submitted.

When rendering a CLOB on a page, developers can choose from one of two source types: an APEX collection or a SQL query. The SQL Query option is a little easier and more direct as the developer doesn’t need to create and populate a collection. However, when submitting a CLOB, the value is always submitted to a collection. This allows the developer to then adapt their page processes (or subsequent PL/SQL processes via dynamic actions) to grab the CLOB value from the collection and process it further as needed.

Because both the render and submit phases can take some time, depending largely on the size of the CLOB and the speed of the network, we added some declarative settings to easily add a modal dialog with a loading message and image. If multiple items are being rendered or submitted at the same time the modal dialog will remain open until all CLOBs have finished processing at which time a custom event will be triggered to allow for other actions to follow.


Keywords
enkitec,clob,load,text

Company: Enkitec
Date added: 11.4.2013
Views: 7260
Votes: 5
Reviews: 11
Min. APEX Version:
4.0
Share on Facebook
Digg! Share on Digg
Save This Page
Link to:
Download
download apex plugin
If something is not correct please report it here: Report Listing
Do you have a question about this Plugin? Want to write a Review or Comment?
Login first.
Reviews / Questions / Comments are e-mailed to the author of the Plug-in.
8 
Apex 5 version
by Roger
on May 20, 2016
Enkitec link is broken, for Apex5 try: https://github.com/OraOpenSource/apex-plugin-clob-load

Help page archived at: http://web.archive.org/web/20151008135018/https://www.enkitec.com/products/plugins/clob-load/help
8 
Apex 5 version
by Roger
on May 20, 2016
Enkitec link is broken, for Apex5 try: https://github.com/OraOpenSource/apex-plugin-clob-load

Help page archived at: http://web.archive.org/web/20151008135018/https://www.enkitec.com/products/plugins/clob-load/help
8 
Apex 5 version
by Roger
on May 20, 2016
Enkitec link is broken, for Apex5 try: https://github.com/OraOpenSource/apex-plugin-clob-load.

Help page archived at: http://web.archive.org/web/20151008135018/https://www.enkitec.com/products/plugins/clob-load/help
0 
Apex 5 version
by Roger
on May 20, 2016
Enkitec link is broken, for Apex5 try: https://github.com/OraOpenSource/apex-plugin-clob-load.

Help page archived at: http://web.archive.org/web/20151008135018/https://www.enkitec.com/products/plugins/clob-load/help
0 
Not available for download?
by apexfr2
on May 19, 2016
This plugin seems not available for download anymore, missing the download box, following the link redirects to another business Accenture
0 
Not available for download?
by apexfr2
on May 19, 2016
This plugin seems not available for download anymore, missing the download box, following the link redirects to another business Accenture ...
0 
Not available for download?
by apexfr2
on May 19, 2016
This plugin seems not available for download anymore, missing the download box, following the link redirects to another business "Accenture"...
0 
Not available for download?
by apexfr2
on May 19, 2016
This plugin seems not available for download anymore, missing the download box, following the link redirects to another business "Accenture"...
0 
APEX5
by Jozef
on March 2, 2016
Thanks for the plugin.

I have the same problem in APEX 5 as bellow.
Is there some option to upgrade this plugin to be compatible with APEX 5?

Thanks.
J
0 
APEX5
by Jozef
on March 2, 2016
Thanks for the plugin.

I have the same problem in APEX 5 as bellow.
Is there some option to upgrade this plugin to be compatible with APEX 5?

Thanks.
J
Powered by Sigsiu.NET RSS Feeds

Disclaimer: The APEX Plugins on this site are not supported by Oracle Support Services.

If you have a question about a Plugin or need support: Login and select the plugin detail page. At the bottom you can enter your Question / Review / Remark.
Your message will be sent to the author of the plugin.