Oracle Cursor (next, Prior) item

From: <weiq_at_webworks.ca>
Date: Fri, 12 Feb 1999 16:00:24 GMT
Message-ID: <7a1j6h$as6$1@nnrp1.dejanews.com>

Hi,

I am wondering if any one can help me how to get the next and previous item in the cursor based on the item mathed the item passed in the store procedure

eg:

 PROCEDURE sp_getPreNextId(IN_ID      IN  employee.id%TYPE,
                           Out_PreId  OUT employee.id%TYPE,
                           Out_NextId OUT employee.id%TYPE) IS

       CURSOR cur_AllEmployeeId  IS
                 SELECT ID outRow
                 FROM  EMPLOYEE
                 ORDER BY FNAME;

Thanks and have nice day

Wei E-mail: weiq_at_cs.dal.ca

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Feb 12 1999 - 10:00:24 CST