How to get a view on packages larger than 30K in Oracle Portal

For a project with Oracle Portal, I had to do some lookups in packages and procedures on the database to get some information about the project.   Since I wasn’t working full-time for this project I had no access to the DB, except via the portal itself.

Several times I had the problem that the client wanted a quick answer for his question, but therefor I needed to dig into the code that was developed in the past. The problem was that the size for editing/viewing a package or procedure was limited to 30K and since there where several packages bigger than 30K, I couldn’t give them a quick answer.

If you only want to read the packages(not edit), there is a very easy portal solution for this problem:
Continue reading

ADF 11g – Take Aways

Monday morning I followed the session of Lucas Jellema, Putting a Smile on ADF Faces. The presentation was great, especially because Lucas created a demo with some of the features integrated that Steve Miranda had shown in the keynote session regarding Fusion Apps.

Take aways from this session:

  • A table can fetch data in an asynchronous request, so you can scroll throug records and the server will get more data as needed. In other words you don’t need to use the pre-defined row-set anymore which was necessary in previous versions, e.g. show 10 records at a time)
  • Client Side and Server Side support has been greatly improved so developers can tackle functionality where it’s supposed to happen. API’s are available to be able to work only on the Client Side or Server Side using Listeners. Using the Client Side scripting for example, you can now use javascript and client Side API’s instead of needing to use backing beans or managed beans. For Example using propertyListeners on the client side to trigger events.
  • You can embed tables inside the panelCollection-component to be able to change to look and feel of a table component, e.g. detach the table to a separate region to have more display-functionality. What you can do know is hide columns, filter on records at run-time which can give you the same dynamic look and feel as with using interactive reporting within Apex
  • Autosuggest-functionality to be able to get a list of valies according to the information the end-user has putted in. The event keys kan be intercepted by the Client Side Listener, calling the Server Side Listener which can then push the data to the Client Side
  • The Data Push mechanism or Active Data Services give you the ability to work on real-time data without the need to fetch the data yourself which is a great enhancement

And of course there’s lots more in the ADF 11g release that will enhance user friendliness and capabilities for the developer to give you a true Web 2.0 experience. The hierarchy viewer-component can be viewed already on the rea-side. Have a look at what ADF has to offer you in a sandbox-environment where you can start playing around with the functionality.

OOW – Day 3 – Keynote Thomas Kurian

Today I had busy schedule as well … so let’s start talking wright ;o)

The first session I attended was the keynote-speech of Thomas Kurian:
The acquisition of Coherence has been a huge step forward in datagrid enabling the Oracle Fusion Middleware stack.

Coherence could be defined as ‘in parallell processing of transactions which live in-memory and are spread over differnet datagrid engines.

Which benefits can we gain from it:
- 30% more benefit
- less power needed
- less feeds needed
- half as many servers needed

and more over, Coherence still offers absolute reliability and consistent availability.

- Application Server is JEE 5 Compatible which supports WS-* (quality of service), JAX-* and EJB 3.0

What about the OFM offering:
- IDE that integrates all the different technologies of SOA together, such as esb and bpel design, web application design using ADF or Webcenter. By using customizable skins Oracle offers the possibility to use the same application as a JSF application or rich client interface using AJAX, DHTML.

In 11g we will be able to design SOA Composites inside JDeveloper which will hold the entire SOA-technology stack, such as BAM, BPEL, ESB and will give the user the ability to drill down into the specific service he/she’s interested in.

Bpel has been extended :
- System-oriented processes: such as the prepackaged processes for integrating with Siebel, SAP, ERP-systems, …
- Human processes
- Document-centric processes (excel sheets, word documents, …) will all be transformed to service-enabled messaging formats such as pdf, xml, …

Complex Event Processing (CEP) & Activity Monitoring has been added as well to add the ability to collect events in memory and perform analytics on these events use CQL, the Complex Event Processing query language.

Enterprise Manager is now a fully featured management applications that will hold all needed functionality to control services and OWSM has been integrated as well. You will have one single point of thruth to manage your entire SOA enabled application.

Throughout a ‘Best Bank’-demo Thomas has shown us the different customer needs and business value throughout the Oracle offering.

The technology-stack that was used throughout the demo:
- JDeveloper
- SCA Composite Editor which is an add-on in JDeveloper 11g
- ADF Developer and ADF Task Forms
- BAM Datacontrols
- Shared repository to give the user the ability to change the web application on any given time he wants.
- All office applications are now supported as well (Excel spreadsheet is build into web application)

The Web 2.0 or Enterprise 2.0 Experience:
- Universal Content Management
- Conversion and filtering of content using tags and categories
- Render files to web-enable the application (word, Excel, … to PDF, XML)
- Open Web Content Management system giving the end-user and developers the possibility to use any UI technology they want such as PHP, JSP, JSF, Ruby on Rails, …
- Archiving and Record Management
- Webcenter (dashboard to integrate adf, portal, discussion forums, forms, third-legacy applications, …)
- Webcenter spaces to share information and create an online community
- Composer: give the user the ability to adjust the application at run-time by dragging and dropping compoentns from the Composer.