Monthly Archives: January 2008

Oracle Forms 6i officially unsupported tomorrow

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

Giving feedback on Oracle Development tools

Oracle has created a Development Tools User Research team ( 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
  • 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’m off to New Orleans in June for ODTUG Kaleidoscope 2008

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!

Cleanup of files uploaded to Oracle Portal

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.