OOS Utils Beta

We're pleased to announce that OOS Utils, a PL/SQL utility library for Oracle, is now available in beta our Github page: https://github.com/OraOpenSource/oos-utils

Before its initial release we'll blog about some of the neat features and how they can help with your development. 

A few things to note:

  • The code is still in beta. As such things may change, methods may be moved, etc
  • If you have any feedback, suggestions, questions, etc please leave a note on the project's issue's page.

Thanks to everyone for the suggestions and feedback so far!

Introducing APEX Text Messages

A while ago, our friends at Pretius released a great application for the global APEX community called translate-apex.com. This application contains a collection of translations for Oracle Application Express. These translations are for the internal APEX Text Messages for system messages like 1 error has occurred.

During the same time, one of our developers, Aljaz Mali was working on an application which helps create and manage these Text Message translations. We're pleased to announce that this application is now live and open sourced!

Instead of documenting everything that the application can do, you can go try it out now: apex.oracle.com/pls/apex/f?p=88328 and using demo/demo123 as the login credentials.

If you want to help contribute to the project or download the application go to our Github project page. Please submit any of your feedback, issues, or enhancement requests on the issues page. If you create a translation in a language that isn't on translate-apex.com you're encouraged to upload it to their site and share with the rest of the community.

Big thanks to Aljaz Mali for all his time and effort on this project!

Introducing APEX-SERT

We’re pleased to announce yet another addition to OraOpenSource: APEX-SERT! APEX-SERT, formerly known as the commercial product eSERT, is an APEX application that is designed to identify and help remedy any security vulnerability in your APEX applications.

APEX-SERT installs one time into your instance of APEX and is instantly available to any user with APEX developer credentials. By default, users can evaluate only applications in their respective workspaces. However, APEX-SERT allows an administrator to allow users to evaluate across any workspace.

APEX-SERT can also be scheduled to evaluate a single application or even a group of applications at a specified interval. Results of each evaluation can be e-mailed upon completion - even to users who are not APEX developers.

APEX-SERT 4.2 - which is compatible with APEX 4.2 - is available today. APEX-SERT 5.0 - which will be compatible and updated for APEX 5.0 - should be available in the next month or so. You can download all releases and the source code from GitHub here: https://github.com/OraOpenSource/apex-sert

Introducing APEX Diff

This year at Kscope 15 we announced several projects that we are working on. We're pleased to announce that one of these projects, APEX Diff, is finally ready (well at least an Alpha version)!

The goal of APEX Diff is simple: Create an export of an APEX application in a JSON format so that it can easily be compared/diffed with another version of the same appliation. By doing so it's a lot easier to see what has changed when comparing two applications rather than trying to read through the default .sql export file.

The following aninmation shows APEX Diff in action.

  • config.json file, with dev as the connection name.
  • Modify a region name in an APEX application (147)
  • Run APEX Diff, using Node.js
  • Compare old vs. new .json files to show the change and where it occured.
    • In most cases this would be done via a diff from versions checked into a version control system.

Special thanks to Kris Rice for adding the required features into SQLcl, which this project leverages.

For more information go to the official project page on GitHub: https://github.com/OraOpenSource/apex-diff. Please submit any feedback, issues, or enhancement requests on the issues page.

Logger 3.1.0: Released

We're pleased to annouce that Logger 3.1.0 is released! It is available for download from the release downloads page.

For more information about this release please read the post on Logger 3.1.0 Beta or view the change log.

If you have any feedback please submit on the project's issue page. If you want to see what we've got planned for the next release check out the feature list for Logger 3.2.0!