I finally made it…

Today at 00:50 (when normal people are already sleeping) I finally made it to release version 1.0 of the Oracle APEX development framework, called ApexLib.

Today I was the hole day at a customer and had no chance to blog about it. So I was really surprised than when I came home and checked my Google Reader, John Scott was faster than me, because he had already blogged about my framework. Thanks John for your nice posting!

Maybe you have noticed the version jump from v0.17 to v1.0, but I thought after implementing Browser Validation for Tabular Forms and new installation scripts, it was time to go to version 1.0. And to be honest, with the old numbering it would have taken forever before 1.0 would have been reached 🙂

So what’s in this new release?

As you can see from the following list, there are some enhancements and some bug corrections.

  • CR# 1634286: Client side validation for tabular form
  • CR# 1635730: Possibility to install ApexLib into it’s own schema
  • CR# 1638777: Add an uninstall script
  • CR# 1636235: Only transfer label template metadata if used
  • Bug# 1640936: Check for dates which contain 08 or 09 fails
  • Bug# 1635198: Two digit year is always prefixed with 19
  • Bug# 1635376: setNlsData raises “ORA-06502: Numeric or value error”

First of all, the browser validation has been enhanced to check Tabular Forms too.

The second big change is the installation process, I have written a new HTML installation How-To, which I think is better readable than the previous text version and it’s now possible to install the ApexLib Framework into it’s own database schema (eg. APEXLIB), so that you don’t have to mess the FLOWS_xxx schema anymore. It even contains an uninstall script, in the case the framework isn’t what you have been looking for.

If you have already used the framework, I would suggest that you run the uninstall script and do a fresh installation.

If you want to test the Tabular Form Browser Validation, check out the demo site!

Want to know more about the ApexLib Framework, checkout the following links:

In the next few days I will write a posting about how to just use some features of the framework, in the case you don’t want to use all the features.

Any suggestions, improvements, “must haves” for the framework are very welcome! But also “negative” feedback is very welcome. Eg. if it doesn’t work for you or why you can’t use the framework, … I would like to use this feedback to improve the framework.


10 thoughts on “I finally made it…

  1. Patrick,

    I have not tried the framework yet – and we do have some APEX development here. The post is definitely a motivation to try the framework and the benefits of the framework. Does the framework work with HTML DB and Oracle XE?

  2. Hi Vidya,

    it’s designed to work with the versions 2.0 and 2.1 (which is included in Oracle XE). But I have to admit that I haven’t tested it with this versions. But the good news is that I got feedback from users that it works as expected 🙂


  3. Hi Patrick,

    in your document about “How to integrate” you described at 3. to create a region on Page0 of Type “PL/SQL Dynamic Content”. In the PL/SQL source you showed I miss some examples of procedures and/or functions with parameters ! What about these ?

    (cu in the forum)

  4. Hi Heinz,

    I’m not sure what you mean with “procedures and/or functions with parameters”. Probably the best is if you write me an e-mail (you can find it in the profile) and I will send you my phone number, so that we can have a talk. Probably you live just a few blocks away 🙂


  5. Hi Patrick,
    could you roughly estimate in percents the difference in performance between options to install ApexLib into separate schema vs application schema?

  6. Hi Edward,

    haven’t done a real performance test yet. Just looked at the explain plans which are generated for the statements and they are a lot more joins done when using the APEX repository views.

    But what I have seen from my observation, the time used by ApexLib to add the additional infos to the page is really fast, just 0.01-0.02 overhead. So it probably only matters if you have a higher load on your DB.

    About the question install it into the application schema or into it’s own schema. I would suggest to install it into it’s own schema, to separate it from your existing code. Another advantage is that you can grant it to several applications without having to install it several times.

    The decision to installation into it’s own schema is independent if you use the direct access or just the APEX repository view access.

    Hope that helps

  7. Patrick,
    thanks for quick response. The only thing that keeps me installing ApexLib into dedicated ApexLib schema yet is that we have test env on the same server as prod.
    I’m in the process of migrating ApexLib from v.0.15 to the current v.1.0 I’ve noticed a minor bug: ApexLib_uninstall.sql doesn’t drop functions V, NV, DV and synonym wwv_flow_conditions.

  8. Hi Edward,

    what about creating two separate ApexLib schemas. eg APEXLIB_TST and APEXLIB_PRD or APEXLIB_0015 and APEXLIB_0100? This could be an option for you to separate the different ApexLib version you may have.

    I will create a bug entry for the uninstall script.


  9. Hi Patrick,

    Now i desperately need to use oracle applicaion express which i have already installed. unfortunately i cannot log in. below is the tail of the installation log file…..all the other parts above this section contain no errors…..i can send the whole log file if you wish

    is there a problem with my installation? if so what is the can i do? after three/four attempts to login i get the 401 unauthoried error.


    Thank you for installing Oracle Application Express.

    Oracle Application Express is installed in the FLOWS_030000 schema.

    The structure of the link to the Application Express administration services is as follows:

    The structure of the link to the Application Express development interface is as follows:

    — Updating user account expiration. ——-
    timing for: Upgrade
    Elapsed: 00:00:02.00

    Performing Application Express component validation – please wait…

    ERROR at line 4:
    ORA-06550: line 4, column 8:
    PLS-00306: wrong number or types of arguments in call to ‘LOADED’
    ORA-06550: line 4, column 8:
    PL/SQL: Statement ignored
    ORA-06550: line 7, column 13:
    PLS-00306: wrong number or types of arguments in call to ‘UPGRADED’
    ORA-06550: line 7, column 13:
    PL/SQL: Statement ignored
    ORA-06550: line 9, column 13:
    PLS-00306: wrong number or types of arguments in call to ‘LOADED’
    ORA-06550: line 9, column 13:
    PL/SQL: Statement ignored


  10. Riria,

    I’m not sure why the dbms_registry calls didn’t work, probably it’s the best when you post your problem to the OTN APEX Forum. There are a lot of people who have more experience with installation problems.

    I think your authorization error is not related to APEX it’s related to Web-DAV/XMLDB. But again, I think on the forum you will find the proper solution.


Comments are closed.