Execute DB function and get its value through an VO attribute

Last Updated on: 14/12/2010 

Create a Transient attr "Mapped to  Column or SQL"

In the Expression put the call passing the appropriate params

+: No need to write java code to call it

-: Execute it for every row

-: Can pass as params only the attr of the same table.

Alternatively, check related ADF How To  Call a DB PROCEDURE or FUNCTION from ADF

+: You decide when to execute

+: Can pass any param 

-: Got to write java but this is not so hard with DbCall. ;)