vesterli.com

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.

No Comments »

I’ve been considering how to describe the difference between Oracle WebCenter, Portal and Unified Content Management (what used to be Stellent), and I’ve come up with this picture:

It considers your requirements in two dimensions: How much content management do you need and how much application development do you need. To put in in another way: Unstructured data like documents need document management, and structured data needs applications.

If you need a lot of document management, you need Oracle UCM. If you need sophisticated applications, you might need WCS. But in general, Oracle Portal will cover quite a lot of application functionality as well as content management.

No Comments »