Forum Stats

  • 3,815,945 Users
  • 2,259,117 Discussions


Search screen based on Procedure

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 :

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.