At the Oracle Forms Strategy event at the local Oracle office in Ballerup, Denmark, quite a few people admitted they were still running Oracle Forms 6i (client/server, of course). They are officially on their own from tomorrow, when extended support for Forms 6i runs out. If you are still on Oracle Forms 6i, it is definitely about time to think hard about your future direction.
You have several options:
- Migrate to the latest version of Forms (Oracle promises Forms support to 2013 and beyound). You can do this manually (it’ll take you 1-2 hours per form on average) or use a tool. At Scott/Tiger, we recommend (and sell) the PITSS.CON tool, but there are other (less expensive) options as well
- Migrate your code to something else (Java or .NET). There are tool vendors offering to do this more or less automatically.
- Develop new code (ADF strongly recommended). To reuse the business logic in your Forms, move it into the database – that allows you both to call it directly from Java, or to generate PL/SQL Web Services to call from any application
Oracle has created a Development Tools User Research team (firstname.lastname@example.org) whose focus is on learning more about Developers and the tools that they need to perform their jobs. They are looking for users of development tools to assist them and to participate in their studies – both novices and experts. You can:
- Tell them what you know. Send your feedback on tools, feature requests and ideas to email@example.com
- Volunteer to participate in Usability Studies. Complete the user profile form on the Oracle UI: Get Involved Page.
- Participate in WebBased Surveys. These surveys are updated quarterly and contain information that Product Managers and Developers have specifically requested
I’ve gotten two papers accepted for the ODTUG Kaleidoscope 2008 conference: “What’s Hot and What’s Not – An Overview of Oracle Development Tools” and “Like Open Source Forms – ADF Swing Applications with JDeveloper 11g”. If you’re an Oracle developer, this is definitely the place to be. Check out who else is coming:
- Duncan Mills on late-breaking Fusion developments!
- Mark Rittman diving deep (three-hour session!) into Business Intelligence!
- Tom Kyte on 11 best features of 11g!
- Patrick Wolf (Oracle’s ’07 APEX Developer of the Year!) on using open source with APEX!
- Peter Koletzke on everything Fusion (embarrassing how much this man knows!)
- John Scott (Oracle’s ’06 APEX Developer of the Year!) tipping and tricking BEST APEX!
- Dimitri Gielis on advanced charting in APEX!
- Paul Dorsey breaking down Fusion—an overview in a day-long symposium format!
- Steven Feuerstein on weird PL/SQL!
Oracle Denmark is hosting an Oracle Forms Strategy session featuring Grant Ronald (and others, including myself) on January 29th at the Oracle office in Ballerup. If you are based in Denmark and are running Oracle Forms, consider dropping by.
When you upload content to Oracle Portal, it ends up in the WWDOC_DOCUMENT$ table and the content can be retrieved using WWDOC_ADMIN.GET_DOCUMENT_BLOB_CONTENT.
But what happens if you upload files to a portlet and they are not used as items? Do they just hang around, cluttering WWDOC_DOCUMENT$?
Fortunately not. You might not be aware that Portal installs a session cleanup job (with DBMS_JOB), running every 24 hours. This job cleans up after sessions more than 7 days old, and one of the things cleaned up is records in WWDOC_DOCUMENT$ that have not become items (i.e. the PATHID column value is 0 (zero)).
This of course also means that you should move the content to a table of your own if you intend to keep it…
Refer to the Portal documentation or Metalink note 336203.1 for more information.
I’m just done reviewing abstracts for the ODTUG Kaleidoscope conference, which will be in New Orleans June 15-19. As usual, the quality is awesome – this will be the place to be for a serious Oracle developer. I’m hoping to get at least one of my three abstracts accepted so I get to go, too.