Donnerstag, 9. September 2021

Interactive Report - resize image the smart way...

 I just came across a smart tipp how to resize (not compress) an image of a BLOB in an IR.

In the page properties under CSS- inline 

just put

img {

width: 100px;

height: 100px;


and adjust the pixel size and you are done:

thanks to Rex Araya

and "Learning a'peks"

Dienstag, 17. August 2021

APEX - Render PDF in Region

 sorry for crossposting - but this one is worth mentioning:

Thanks to Vinish Kapoor and his detailed post on rendering a pdf or image in a static region.

This is a working example for APEX 21.1 (not tested on other versions)

The steps in short:

1. have a table (my_table) with a blob column and mimetype column - and id ofcourse...

2. create an application process (in shared components) of type AJAX callback

  vBlob blob;
  vmimetype varchar2(50);
  SELECT BLOB_column, mimetype_column INTO vBlob, vmimetype
                FROM my_table
                WHERE ID = V('P3_ID');
  htp.p('Content-Length: ' || dbms_lob.getlength(vBlob)); 
  when no_data_found then

3. create a page with a region type static content and insert this:

<p align="center">
<iframe src="f?p=&APP_ID.:0:&SESSION.:APPLICATION_PROCESS=display_blob:NO:P3_ID,&P3_ID." width="99%" height="1000">
Note: contrary to Vinishs example 
I had to delete one " : " between NO and :P3_ID... (as shown above)
4. for my purpose I created a 2nd region of type IR or 
classic report and put a link on one of the columns to 
point to the same page 3 ... and defined a hidden item 
named P3_ID.
So as you can see from the above the APEX-URL calls 
the APPLICATION_PROCESS "display_blob" and passes 
the ID from the page to the process... which in turn 
renders the pdf within the iFrame.
I put the report on the left side of the page and 
the 2nd region aside of it.
Have fun and thanks to Vinish again! Great job !

Mittwoch, 31. März 2021

APEX PLUGIN Tutorial von Ronnie Weiss - sehr empfehlenswert !

Danke an Ronnie Weiss für sein akribisch erstelltes APEX Plugin Tutorial

Mit Anleitungs-Video und Beispiel-Code in jedem Tutorial.

Total cool ! Dauert ca. 2 Stunden zum Mitmachen. 

Mein Ergebnis seht Ihr hier: (Link zur Seite in der Oracle cloud

Ronnie ist übrigens ein eifriger APEX Plugin Entwickler. Seine sehr hilfreichen mittlerweile 29 Plugins sind auf APEX.WORLD unter Plugins zu finden.

Noch besser: es gibt zu seinen Plugins eine Demo-Anwendung, die man auch runterladen und zum Ausprobieren auf seinem eigenen Workspace installieren kann.

APEX-CHARTS - ein interessantes js-feature

Nach einem Plugin-Tutorial von Ronnie Weiss (2 Stunden beim Mitmachen... sehr empfehlenswert!) kam ich zufällig auf die APEXCHARTS - Javascript library apexcharts.js

Auf dieser Seite findet Ihr die ausführlich Dokumentation.

Donnerstag, 4. März 2021

Jasper Reports Studio 6.16 - tipps

We are presently extensively using Jasper Reports Studio 6.16 and JR Server installed at Maxapex.

Insert SYSDATE in report:

1. define a variable
2. enter in "expression" : new SimpleDateFormat("dd/MM/yy").format(new Date())
3. put the variable as a field on the report

or try to insert from the "Current Date" from the "Composite Elements" (right hand).

a textfiled will be generated [new java.util.Date()] and the standard format (pattern) is: MMMMM dd, yyyy

if you like adjust the date format, you can use --> Textfield --> pattern --> and an editor can be opened and you may choose from various formats

Generic procedure:

in my previous project I always had defined the pl/sql process on respective pages - now, as we will have more reports to produce I have defined a generic procedure in the database reading as follows:

  Q_PARAMETER IN VARCHAR2,  -- used for ID of a dataset
  REPORT_NAME in VARCHAR2   -- used for the report name
) AS 
  l_additional_parameters varchar2(100);
-- set the url for the j2ee application
-- better retrieve that from a configuration table
--  xlib_jasperreports.set_report_url(:G_REPORT_URL);
-- construct addional parameter list
l_additional_parameters :='PARAMETER01='||PARAMETER01;
-- call the report and pass parameters
xlib_jasperreports.show_report ( 
    p_rep_name     => 'XXXXXX/'||REPORT_NAME, -- Replace your Workspace name
    p_rep_format   => 'pdf', 
    p_data_source  => 'XXX_A123456_1234', -- REPLACE !!
    p_out_filename => 'Dokument_'||REPORT_NAME||'.pdf',
   --    p_rep_locale   => 'de_DE',  -- this is optional
   --    p_rep_encoding => 'UTF-8',  -- this is optional
   p_additional_params => l_additional_parameters);
   -- stop rendering of the current APEX page
  apex_application.g_unrecoverable_error := true;

Within the APEX page no. 16 I defined a button, which calls the pl/sql process namely:


on the page it looks like:

Assuming one like to save the report in a table straight away.... - the next tipp will contain that procedure...

Donnerstag, 25. Februar 2021

Oracle Autonomous DB (Oracle cloud) - Sending Email from APEX (not for free)

Viele experimentieren schon mit APEX innerhalb der Oracle Cloud ADB (ALWAYS FREE...) - aber so ganz FREE ist es dann doch nicht.

Chaitanya Koratamaddi, Oracle product Manager, beschreibt in seinem Post vom 2. Februar 2020, wie APEX_MAIL aufgesetzt wird... hier der Link zum Post.

Genutzt wird dazu das neue APEX Feature "Automation" (unter shared compoments).

Aber: zu Anfang heißt es auch in der 


  • The instructions in this blog post use the free promotion account that is within the trial period. When your trial is over, your account will be limited to Always Free resources. You need to upgrade to a paid account to continue to use the Email Delivery. 
Schade eigentlich....

Ein "Workaround" scheint zu sein - wenn man APEX_MAIL nutzen möchte, sich für wenige Cents einige Cloud Services dazuzukaufen....

Allerdings blicke ich bei der Oracle Preispolitik für die Cloud und ADB nicht durch... welcher Service das sein könnte...

Ich recherchiere mal....wenn ich mehr weiß, werde ich es hier schreiben...

Freitag, 5. Februar 2021

APEX 20.2: DBMS_SCHEDULER becomes "APEX Automation"

sorry for crossposting ! - but I found this extremely interesting and helpful:

Oracle PM Salim Hlayel writes about the new "Automation"-feature  - based on the DBMS_SCHEDULER:

check it out !!!

Good luck !