developers

    Forum Stats

  • 3,873,649 Users
  • 2,266,621 Discussions
  • 7,911,596 Comments

Discussions

I want to create stored procedure in oracle with Sorting columns and total pages request

User_6ZU96
User_6ZU96 Member Posts: 1 Green Ribbon

create or replace procedure Cust_role_details

(

 roleId in varchar2,

 status in varchar2,

 SortIndex in varchar2,

 startingRowCount in varchar2,

 pageSize in varchar2,

 ttlRecordsCntReq in varchar2,

 Cust_role_details out varchar2

)

is 

begin 

 OPEN Cust_role_details FOR

 select   

 role_id,role_name,role_desc,resource_details,status

 from 

 cust_roles

 where

 status='ACTIVE';



END Cust_role_details;

Tagged:

Answers

  • L. Fernigrini
    L. Fernigrini Data Engineer Sr Consultant Member Posts: 4,094 Silver Crown

    What have you tried? Where does it fail?

    This is not a Free Coding Service, we will help you solve a problem but will not work for you. Post a simple version of the procedure you have tried and we can help you fix any problem.

developers