04 November 2010

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. ;)

No comments:

Post a Comment

You might also like:

Related Posts Plugin for WordPress, Blogger...