ADF 11g: Passing Information to Bind Variables

Technical Expertise for ECM

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.

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…

View original post 631 more words