Saturday, August 27, 2011

How to use database functions in BO

Predefined functions created in the database can be used in the business objects by the following syntax

schema name . function name ( )

for eg :

If you have a function called amount() then we can use the function in the BO by creating an object and in the select statement we have to give the following syntax along with the parameters which the functions take.

ora$ert.amount() ora$ert - schema name