Tuesday, December 9, 2014

APEX IR XLSX Downloader V1.2.3

I have just published Release 1.2.3 of my APEX IR XLX Downloader.

André Meier had a look at my package after DOAG 2014 and pointed out some hick-ups he encountered while using it.
He also made a big effort to bring some proper code formatting and explicit conversions into the XLSX_BUILDER_PKG which is one of the libraries used.

A huge thank you to André, as many of the changes are based on his contribution.

Changes

  • XLSX_BUILDER_PKG
    • Explicit Conversions
    • Code Formatting
    • Better CLOB building using VARCHAR2 buffer (as shown in a previous post)
  • APEXIR_XLSX_PKG
    • If splitting report_columns string would produce a NULL index this is now taken care of and a warning is send to the APEX debug messages.

As always the source code can be found in the GitHub Repository.
ZIP files for all my GitHub projects can now be found on my GitHub Page.

The new demo application is currently under development and will be published soon.
I'm currently creating some sort of packaged application which will better showcase all the different options available.

Stay tuned for more to come.

2 comments:

  1. Hi Moritz,

    Is you plug-in compatible with Apex 4.1? I am getting the following error "APEX_IR.T_REPORT must be declared" which is part of Apex 4.2. Do you have any older version that works with 4.1 that I can download?

    Thank you for this plug-in!

    ReplyDelete
    Replies
    1. Hi Erick,
      I do not have any version which is compatible with APEX < 4.2.
      Without the function apex_ir.get_report it's near to impossible to really derive the IR query.

      Delete