Category Archives for "Oracle"

Oracle WebCenter Content Licensing

I thought I would share out the following information because of how often it comes up. When dealing with Oracle WebCenter Content or WebCenter Imaging, it is good to know what restricted use licenses each product includes. The following guide from Oracle shows you what products are bundled together in the WebCenter Suite.

http://docs.oracle.com/cd/E28280_01/doc.1111/e14860/webcenter.htm#sthref118

Continue reading

ADF 11g: Passing Information to Bind Variables

For the past year, I’ve been working with a customer on a large Oracle BPM project.  As part of the project there are a couple forms written using Oracle’s Application Development Framework (ADF.) I’d like to do a small series on this blog of useful techniques that have helped me with a successful implementation in a large scale production environment. Today, we’ll be talking about how to pass information from the ADF binding layer to a named parameter that is setup on a view object in the model layer.  This comes up pretty often and there are some neat things you can do using the technique.

Let’s take a look at our view object first.

The query for the GetEmployeesInDepartment view object.

The query for the GetEmployeesInDepartment view object.

For this discussion we are using the HR sample schema that comes with an Oracle database. As you can see this view object uses a query that has a single bind variable that represents a department id. Its result set will be all the employees which belong to the supplied department. Our use case is going to be a table that will display employee information based on the department selected in a drop down list. There are many ways to do this type of thing in ADF and this isn’t necessarily the best use case for it but it has the advantage of being simple to follow and explain. We will talk a bit about some other uses for this technique later on.Continue reading

Converting Image Files

At some point there is going to be a need to convert an Imaging Systems image files from one format to another format when moving to a new Imaging system.  ILINX® Import can be used to handle the conversion.

Continue reading