Skip navigation.

Development

Case Study: Oracle Forms Migration to Formspider

Gerger Consulting - Thu, 2015-04-16 01:55
TEAM GmbH, a Formspider customer from Germany, has successfully migrated their product ProStore from Oracle Forms to Formspider. We recently did a joint webinar with TEAM GmbH about their project. In particular we talked about the following topics:

- What other products did TEAM look at?

- Why did TEAM choose Formspider?

- What are the benefits of using Formspider?

- What is it like to work with the company behind Formspider?

- What was TEAM’s approach to Forms Migration?

- A demo of the application

The webinar was quite popular with over 50 attendees. TEAM Division Manager Frank Zscherlich and Product Manager Michael Wibberg answered many questions from the audience.

Below is the recording of the webinar. If you are looking for a way to migrate your Oracle Forms applications to a newer technology, I highly recommend you to watch it.


Oracle Forms Migration to Formspider from Yalim K. Gerger on Vimeo.

You can also watch a short demo of the migrated application below.


Demo of an Oracle Forms Application Migrated to Formspider from Yalim K. Gerger on Vimeo.
Categories: Development

Oracle APEX 5.0 released today

Dimitri Gielis - Wed, 2015-04-15 14:34
After 2.5 years of development, today is the day APEX 5.0 is publicly released and ready to be downloaded to install on your own environment.

In my view it's the best release ever. Not so much of the new Page Designer - although that is definitely a piece of art and it increased productivity even further - but because it's the first time whole of APEX got refreshed and every piece was put under a radar to see how it could be improved. All the small changes and the new UI, together with the Page Designer makes it a whole new development tool, without losing it's strengths from before.

Also note that APEX 5.0 enables many new features build on top of the Oracle Database 12c features, so if you're on that database, you'll see even more nice features.

If you wonder if you should wait with upgrading to APEX 5.0 because you're afraid that your current APEX applications break, I can only share that I upgraded many of my applications as part of EA/beta and most of my apps kept running without issues. As always you have to try your applications yourself, but the APEX development team spend a lot of time trying to keep things backwards compatible. But make sure to have a look at the APEX 5.0 release notes and known issues as they contain important information about changes, expected behaviour and workarounds.

You can develop online on apex.oracle.com or you can download APEX 5.0 and install into your own environment.
Categories: Development

Oracle APEX 5.0 Available for Download!

Patrick Wolf - Wed, 2015-04-15 11:43
After a longer development cycle than usual, Oracle Application Express 5.0 is finally available for download! I think it was worth the wait. It comes with a ton of features, here are just a few marquee features. Page Designer Universal … Continue reading →
Categories: Development

APEX 5.0 will be released today

Denes Kubicek - Wed, 2015-04-15 11:14
Great news. Just finished wathching the Google hangout with the APEX team. They confirmed that APEX will be released today. The download should be made available soon. Stay tuned.

Categories: Development

APEX 5.0: Set Cursor Focus for Region Type Plug-Ins

Patrick Wolf - Tue, 2015-04-14 07:19
Complex Region Type Plug-ins might render their own input fields, like our Interactive Report component does with the search field. If a developer had set the page level attribute Cursor Focus to First item on Page in Oracle APEX 4.x, … Continue reading →
Categories: Development

APEX 5.0: New Plug-in Attribute Types

Patrick Wolf - Mon, 2015-04-13 07:03
Besides the Plug-In Attribute Enhancements described in my previous posting, we have also added new Attribute Types in Oracle APEX 5.0 for increased usability in Page Designer. Link to Target Page/Url If your Plug-in had to exposed a Link attribute … Continue reading →
Categories: Development

Ask the Real Experts

Denes Kubicek - Mon, 2015-04-13 01:39
On Wednesday you will have a chance to ask the APEX developers anything you would like to know about APEX 5.0. See this posting from Patrick Wolf or go directly to the registration form in order to get a link.

Categories: Development

In what ways is buckthorn harmful?

FeuerThoughts - Sun, 2015-04-12 16:54
I spent 10-15 hours a week in various locations of still-wooded Chicago (and now nearby Lincolnwood) cutting down buckthorn. Some people have taken me to task for it ("Just let it be, let nature take it's course, etc.). So I thought I would share this excellent, concise sum up of the damage that can be wrought by buckthorn.
And if anyone lives on the north side of Chicago and would like to help out, there is both "heavy" work (cutting large trees and dragging them around) and now lots of "light" work (clipping the new growth from the stumps from last year's cutting - I don't use poison). 
It's great exercise and without a doubt you will be helping rescue native trees and ensure that the next generation of those trees will survive and thrive!
From The Landscape Guys
Buckthorn should be on America's "Most Wanted" list, with its picture hanging up in every US Post Office! Here are a few of the dangers of Buckthorn:
a) Buckthorn squeezes out native plants for nutrients, sunlight, and moisture. It literally chokes out surrounding healthy trees and makes it impossible for any new growth to take root under its cancerous canopy of dense vegetation.
b) Buckthorn degrades wildlife habitats and alters the natural food chain in and growth of an otherwise healthy forest. It disrupts the whole natural balance of the ecosystem.
c) Buckthorn can host pests like Crown Rust Fungus and Soybean Aphids. Crown Rust can devastate oat crops and a wide variety of other grasses. Soybean Aphids can have a devastating effect on the yield of soybean crops. Without buckthorn as host, these pests couldn't survive to blight crops.
d) Buckthorn contributes to erosion by overshadowing plants that grow on the forest floor, causing them to die and causing the soil to lose the integrity and structure created by such plants.
e) Buckthorn lacks "natural controls" like insects or diseases that would curb its growth. A Buckthorn-infested forest is too dense to walk through, and the thorns of Common Buckthorn will leave you bloodied.
f) Buckthorn attracts many species of birds (especially robins and cedar waxwings) that eat the berries and spread the seeds through excrement. Not only are the birds attracted to the plentiful berries, but because the buckthorn berries have a diuretic and cathartic effect, the birds pass the seeds very quickly to the surrounding areas of the forest. This makes Buckthorn spread even more widely and rapidly, making it harder for us to control and contain.
Categories: Development

APEX 5.0: Plug-In Attribute Enhancements

Patrick Wolf - Sat, 2015-04-11 08:51
In Oracle APEX 5.0 we have added several new features to Custom Plug-in Attributes to improve the usability of your Plug-ins when they are used by other developers. Show in Wizard Some Plug-ins do make use of the maximum number of 25 … Continue reading →
Categories: Development

APEX 5.0: Declarative Definition of CSS and JavaScript Files to Load for a Plug-in

Patrick Wolf - Fri, 2015-04-10 04:58
A best practice for performant HTML pages is to load CSS files in the HTML head to reduce redrawing of the page when a CSS file gets loaded. But because the PL/SQL code of a Plug-in isn’t executed util a … Continue reading →
Categories: Development

APEX 5.0: Directory Support for Static Plug-in Files

Patrick Wolf - Wed, 2015-04-08 07:21
Since day one, the APEX Plug-in framework provided the capability to create self containing installations which included all static files needed by the Plug-in. But this file storage was somehow limited in APEX 4.x, because it didn’t allow to reference files with … Continue reading →
Categories: Development

APEX 5.0: Want to learn all about Universal Theme?

Patrick Wolf - Tue, 2015-04-07 15:29
And do you want to learn it straight from Shakeeb Rahman the Designer of Universal Theme? Then you have to sign up for the free ODTUG Webinar on Thursday, April 9 at 12:00PM EDT. That’s 17:00 London, 18:00 Vienna or … Continue reading →
Categories: Development

APEX 5.0: Create Plug-ins as Subscription from Master Application

Patrick Wolf - Mon, 2015-04-06 15:00
In APEX 4.x it was a little bit cumbersome to use new Plug-ins in an application when you followed the best practice to subscribe Plug-ins from a Master Application which contained all Plug-ins of your workspace. Having such a Master Application has … Continue reading →
Categories: Development

Consumer Reports guide on which fruits and veggies to always buy organic

FeuerThoughts - Mon, 2015-04-06 09:32
First, I encourage everyone reading this (and beyond) to subscribe to Consumer Reports and make use of their unbiased, science-based reviews of products and services.

It is the best antidote to advertising you will ever find.

In their May 2015 issue, they analyze the "perils of pesticides" and offer a guide to fruits and vegetables. When you should buy organic? When might conventional be OK for you?

[or, as CR puts it, "Though we believe that organic is always the best choice because it promotes sustainable agriculture, getting plenty of fruits and vegetables - even if you can't obtain organic - takes precedence when it comes to your health.]

Here are the most important findings:

ALWAYS BUY ORGANIC

CR found that for these fruits and vegetables, you should always buy organic - the pesticide risk in conventional is too high.

Fruit

Peaches
Tangerines
Nectarines
Strawberries
Cranberries

Vegetables

Green Beans
Sweet Bell Peppers
Hot Peppers
Sweet Potatoes
Carrors
Categories: Development

Oracle Forms Migration to Formspider

Gerger Consulting - Mon, 2015-04-06 06:59
We’d like to invite you to our free webinar about migrating Oracle Forms applications to Formspider. Join our webinar and find out how the Formspider customer TEAM GmbH from Germany migrated their large (500+ forms) Oracle Forms based product to Formspider with a fraction of the cost compared to the alternatives.The webinar will be presented by Frank Zscherlich (Division Manager, TEAM GmbH), Michael Wibberg (Product Manager, TEAM GmbH) and Yalim K. Gerger (Founder, Formspider).During the webinar, the following topics will be covered:
  • What other products did TEAM look at?
  • Why did TEAM choose Formspider?
  • What is it like to work with the company behind Formspider?
  • What was TEAM’s approach to Forms Migration?
Watch a short demo of TEAM’s new application at this link. This application is built by 5 Oracle Forms Developers.

The webinar is free but space is limited. Sign up now.The Formspider Team
Categories: Development

APEX 5.0: Plug-in Enhancements – Overview

Patrick Wolf - Mon, 2015-04-06 05:54
In the next few days I plan to write a series of blog postings about the Plug-In Enhancements which will be available in Oracle APEX 5.0* The plan is to cover the following areas: Create Plug-ins as Subscription from Master … Continue reading →
Categories: Development

Oracle APEX 5.0 Articles

Patrick Wolf - Fri, 2015-04-03 16:36
With apex.oracle.com upgraded to a pre-production version of Oracle Application Express 5.0, the new release of APEX can already be seen on the horizon. So I thought it’s time to compile a little weekend reading for you.   A number of … Continue reading →
Categories: Development

Ask the APEX Development Team!

Patrick Wolf - Thu, 2015-04-02 16:15
Together with ODTUG, we the APEX Development Team are hosting a Google ‘Hangout’ (with Video) on April 15th, 2015 at 12:00 EDT. That’s 17:00 London, 18:00 Vienna or 21:30 New Delhi time. Our current plan is that all members of our development … Continue reading →
Categories: Development

apex.oracle.com - Upgrade to APEX 5.0

Denes Kubicek - Mon, 2015-03-23 03:16
It is time to get used to the new APEX builder interface. apex.oracle.com has been upgraded to the latest pre-production version of APEX 5.0. Some functionality like "Administration" are not visible any more and you have to search a bit. The overall impression is good and my old demo application seem to still work in the most of the cases.



Enjoy.
Categories: Development

Read Only Item Layout

Denes Kubicek - Tue, 2015-03-17 02:08
The possibility to set the items conditionally to read only is one of the important security features in APEX. Using this feature you can secure your applications and it will not be possible to manipulate the protected item (region or page). The downside of this feature is that it will change the layout of the protected items to some kind of standard, ignoring the previous formatting in the "normal" mode. If you have a form which looks like this:



and change the description item to the read only mode, then the page will look a lot different and will be hard to control:



In such cases you can help yourself in different ways. Using some css or jQuery, you can make those read only items to appear only slightly different. For example, I used this code to change the layout of the description item on page load:

$('#P3_BP_DESC_DISPLAY').attr("readonly","readonly").css({"font-weight":"bold","color":"#ccc","display":"block","width":"240px"
,"height":"120px","overflow-y":"auto","border":"1px solid grey"})


and the result looked like this:



There are also some other more generic methods:

.display_only {font-weight:bold; color: #ccc; display: block; width: 200px}

$('[id*=_DISPLAY]').css({"font-weight":"bold","color":"#ccc","display":"block","width":"200px"})

$('.display_only').css({"font-weight":"bold","color":"#ccc","display":"block","width":"200px"})


The only thing you need to note is that setting an item to the read only mode will create two page elements. The displayed element will get the suffix _DISPLAY added to the corresponding item ID.

Enjoy.
Categories: Development