Hi All,I want create a stored procedure by passing the parameter to top nth recordfor Excreate proc test1(@x integer)asbeginselect top @x empid from emp order by empid descendwhen iam executing iam getting error .Please let me know any other alternative way

shruti.potdar

 Profile Answers by shruti.potdar Questions by shruti.potdar

• Dec 10th, 2008

Solution to your problem:Create Procedure TEST1( p_num number)isv_eid number;begin   select empid into v_eid from EMPwhere empid=(select A.empid from (SELECT empid, rank() over (order by empid desc) RNK FROM emp) A where A.RNK=p_num);dbms_output.put_line('Top'|| p_num || 'emp is ::'|| v_eid);End;/

xambrose

 Profile Answers by xambrose Questions by xambrose

• Jul 19th, 2008

create proc test1(@x integer)asbeginSELECT empid  FROM   (SELECT empid  FROM emp ORDER BY empid )   WHERE ROWNUM = @x;end

Answer Question  Select Best Answer