Forum Stats

  • 3,815,945 Users
  • 2,259,117 Discussions
  • 7,893,340 Comments

Discussions

Search screen based on Procedure

User_BUYLR
User_BUYLR Member Posts: 36 Green Ribbon

Hi Team.


We have a requirement like, There is a PROCEDURE which doesn't have IN and OUT parameters.


We should design a search screen with help of PROCEDURE.


Can anyone suggest to us how we can do this?


Jdev verison : 12.2.1.2.0


Thank you in advance

Best Answer

  • Timo Hahn
    Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,290 Red Diamond

    This sounds like a really complicated solution to me. Why don't you ask for a database view instead of a procedure that creates a result set that in turn had to be converted back to a view?

    If you want to use ADF to it's best, a view object has to be created. Either you use the technique outlined in the doc link I provided, or you let the db guys create and view of let them create a rest service returning the data.


    Timo

Answers