Hi,
My problem is as follows
I am suppose to display 3 records per page in sharepoint by
using a stored procedure in oracle pl/sql.What if records
fetched is in millions.Following is code for stored
procedure wich displays only first three records in
sharepoint.
Create or replace procedure sp_emp(p_pageno number) is
empnum emp.empno%Type;
empname emp.ename%Type;
num number;
Cursor c is
Select empno,ename,r
From (Select empno,ename,rownum r
From (Select empno,ename
From emp
Order by empno))
Where r Between 1 And 3;
Begin
Open c;
Loop
Fetch c into empnum,empname,num;
Exit when c%NotFound;
Dbms_output.put_line('EMP NO: '||empnum||' '||'EMP NAME: '||empname);
End loop;
End;
/
i am not using input parameter p_pageno in my code
Shown below is the invocation of sp_emp showing first 3
recods.
begin
sp_emp(1);
end;
/
EMP NO: 7369 EMP NAME: SMITH
EMP NO: 7499 EMP NAME: ALLEN
EMP NO: 7521 EMP NAME: WARD
Hope u understood my requirement
Sharepoint developer is going to pass page number which i'm suppose to accept as input parameter in my stored procedure
i.e. if he passes page no 3 i'm suppose to display 7 to 9 records or he passes page no 4 i'm suppose to display 10 to 12 records etc
Regards,
Ritesh