Today I passed my exam for Oracle PL/SQL Developer Certified Professional(OCP)... Hurray!
Oracle Application Builder Cloud Service(ABCS) is generally available now.
ABCS is an all-in-one box: software development and database in one service.
Oracle ABCS provides a platform to not only create mobile and web applications in the cloud, but also deploy and host them in a cloud environment.
Development happens in a web browser on a intuitive way by drag&drop objects in a visual environment.
The title of the Contribute event/seminar was "Oracle Forms 12c: Built to last".
Indeed, Forms is built to last. It has been around for over 20 years and it's added to Oracle Fusion Middleware 12c, which is supported until 2023.
Oracle Forms is still running at a lot of Belgian companies looking at the turnout.
Oracle did an update of the support document for Fusion Middleware.
Fusion Middleware 12c(12.2.x) is supported until October 2023(extended support).
Of course this includes Forms and Reports!
But you can also see that the premier support for Forms 11gR2 ends at the end of this year!
Just to remind you, the support is (almost)the same for premier and extended, but you'll have to pay an additional fee for extended support.
I used the employees table from the HR demo schema for my examples which is already available in Live SQL, so you don't have to create anything but the functions used in the scripts.
I've created 4 scripts:
Oracle Compound triggers can be handy when you need to share common data in various timing points, e.g. solving a mutating table problem. You can find an example on the Oracle base website.
For those that are using compound triggers, before 12c the order of the sections were restricted:
I have learned a lot from other people in the Oracle Community over the years and I bet a lot of you have too.
Now it's time to give them some recognition by the means of an award.
Until 15 October you can cast your vote.
These are the categories:
Yesterday I ran into an Oracle Forms bug. Something pretty weird.
In some cases a form raised the following error: "FRM-40737:Illegal restricted procedure SYNCHRONIZE in PRE-FORM trigger".
The code was in it for years, works on the development and production environment, but not on the testing environment.
I started searching for what could be wrong and ended up on "My Oracle Support" and found a bug filed for something similar.
But the solution (more...)