Help me to create stored procedure for paging Using oracle

[santyonline123]

Hi Friends,
I have to create paging using oracle stored procedure for a c#.net application.I have to develop this application without using cursor. I tried following procedure but its giving 1 error as subquery returns more than 1 row. please help me to solve this table.

Table name :customers
Fields:CompanyName,ContactName,ContactTitle,Phone, Fax




CREATE OR REPLACE PROCEDURE temp_page1
(CurrentPage in integer,
PageSize in integer,
TotalRecords out integer)
is
FirstRec NUMBER;
LastRec NUMBER;
p_CompanyName nvarchar2(40);
p_ContactName nvarchar2(30);
p_ContactTitle nvarchar2(30);
p_Phone nvarchar2(24);
p_Fax nvarchar2(24);

BEGIN

FirstRec := (CurrentPage - 1) * PageSize;

LastRec := (CurrentPage * PageSize + 1);

select CompanyName,ContactName,ContactTitle,Phone,Fax
into
p_CompanyName,
p_ContactName,
p_ContactTitle,
p_Phone,
p_Fax
from customers
where (select rownum from customers) between FirstRec AND LastRec
group by CompanyName,ContactName,ContactTitle,Phone,Fax;

SELECT count(*) into TotalRecords from Customers;
END;

/

[debasisdas]

i got the problem
what you are getting is as per the code you have written

but can you pass on few more details .

please specify what is the use of the procedure, what are you going to do with this , do you expect only one out put from the query.

[santyonline123]

i got the problem
what you are getting is as per the code you have written

but can you pass on few more details .

please specify what is the use of the procedure, what are you going to do with this , do you expect only one out put from the query.

Hi,
I am creating an asp.net application. In this application i want to arrange data in multiple pages.User should be able to change number of records per page.For this i am using oracle as the backend and i am going to call this procedure in my frontend i.e. c#.net..

I expect all records means multiple rows should select from the database..