mortenbra / apex-plugins

A collection of Oracle Application Express (Apex) plugins created by me...

apex-plugins

A collection of Oracle Application Express (Apex) plugins created by me...

For more info, check out these blog posts:

• https://ora-00001.blogspot.com/2012/11/apex-plugin-execute-plsql-code-and-return-content-to-page.html
• https://ora-00001.blogspot.com/2013/10/pivot-table-plugin-for-apex.html
• https://ora-00001.blogspot.com/2015/10/mockup-table-region-plugin-for-apex.html
• https://ora-00001.blogspot.com/2015/10/kpi-icon-item-plugin-for-apex.html
• https://ora-00001.blogspot.com/2017/01/apex-plugin-calendar-heatmap-region.html
• https://ora-00001.blogspot.com/2018/02/pivot-table-plugin-for-apex-updated.html
• https://ora-00001.blogspot.com/2019/01/apex-plugin-execute-plsql-code-and-return-content-to-page-updated.html
• More coming...

apex-plugins's Issues

Encountered an error while validating code

This code is giving error when trying to create a plug in in the application.

Execute PL/SQL and return content plugin enhancement- DBMS Alert

Hi Morten.
Recently I created a page with your plugin and use on it the interval setting with value of 5 seconds for refreshing content with data. It works great but than I realize that that´s a lot of requests per minute so I created another version with using DBMS Alert. I have a working solution and now I can only refresh my data using your plugin when something happens in DB and alert is signalled. Therefore, I was wondering that it would be awesome if your plugin could do it same way and if I can only setup alert name in settings for example below interval parameter as an optional setting. What are your thoughts about this idea?

Multiple javascript callbacks bug / Execute PL/SQL and return content plugin

Hi Morten,

i am using your plugin "Execute PL/SQL code and return content" in apex 20.2 application and i manage to find possible bug.

On one page i have 3 dynamic acntions (after page load). Each executes one "PL/SQL Code and return content" with different page element with different data using different page item. Every plugin action has 5s interval for refresh data. Mode is "Replace". The problem is in property "Javascript callback". Every action has setup different Javascript Callback (For Example: loadedA(); loadedB(); and loadedC();)

In page settings in "Function and Global Variable Declaration" definition i have declared all of these 3 JS functions and in everyone of them there is simple console.log("Callback A") with different last letter(A,B or C). The problem is, that somehow plugin register only first JS Function for callback even for the other two javascript callbacks. Result in console, is that there is 3times same text (Callback A).

Thanks for looking in to that and have a nice day ,

Lukas Fiala from Czechia

Pivot table plugin

Hi
How can i set the aggregator to "integer sum" as the default action? And set a column to summerize?
Without need the user drag and drop at screen

Thanks
Lior

Pivot Table stopped to work in Apex 23.1

If the plugin is used on a page, it doesn't show the apex page in browser. It shows a JSON text instead.
Looks like a simple issue, but I couldn't find it out :(

Plugin don't work Apex 5

i tried to install plugin and get error Invalid Plug-in File.

Plugin not working on 21.1

I was using this plugin for many years since version 5, and it was working until version 20, but now i migrate to last version 21.1 and the plugin just don't work, it shows blank region.

Pls Help

l_ajax_id gets invalid characters from apex_plugin.get_ajax_identifier

After migrating our apex, the plugin was broken
upon inspection, I found the l_ajax_id contains invalid characters

We need to change

  l_ajax_id                      varchar(2000) :=  replace(apex_plugin.get_ajax_identifier, '-', '_');
  l_data_name                    varchar2(2000) := 'pivot_data_' || l_ajax_id; 

to

  l_ajax_id                      varchar(2000) := replace(replace(apex_plugin.get_ajax_identifier, '-', '_'),'~~/','_');
  l_data_name                    varchar2(2000) := 'pivot_data_' || l_ajax_id; 

After making the above change it started working properly

Regards
Darshan