Saturday 12 January 2019

Invoke Database Procedure and Function in ADF

Hello everyone
In this post we will learn how to invoke database Procedure and Function from ADF Application

Steps we need to perform
1-Create procedure in database
2-Create method in AppModuleImpl to invoke procedure
3- Run AppModule to test


1-Create procedure in database
        First we need to create procedure in database
        i have created the following procedure in HR Schema





2-Create method in AppModuleImpl to invoke procedure

    Second we need to write a method in AppModuleImpl class to invoke the DB Procedure for that we need
1-go to AppModuleImple class and create method





                           


2- add method to application module client interface




3- Run AppModule to test
       just run your AppModule
       1- Double click on AppModule
       2- Pass parameter value
       3- and click on Execute




Please Feel Free To Ask if you Face any Difficulty 
Like and share to help others
Thanks
Date 12-01-2019



1 comment:

  1. If you're looking to burn fat then you have to try this brand new personalized keto plan.

    To create this service, licenced nutritionists, personal trainers, and chefs have joined together to produce keto meal plans that are efficient, painless, economically-efficient, and delightful.

    Since their grand opening in January 2019, thousands of clients have already transformed their body and well-being with the benefits a great keto plan can offer.

    Speaking of benefits; clicking this link, you'll discover eight scientifically-proven ones given by the keto plan.

    ReplyDelete

Query to get Business unit (ORGANIZATION_ID) Detail in oracle Fusion

  SELECT HAO.ORGANIZATION_ID AS BUSINESS_UNIT_ID,         HAOT.NAME,         HAO.BUSINESS_GROUP_ID,         HAO.EFFECTIVE_START_DATE,       ...