Hello. I am trying to develop stored procedure that will do the following: accept sql query, low limit and number of records as input parameters and return ref cursor as OUT parameter. Resulting recordset which will be accesible thru OUT REF CURSOR must contain "number of records" starting from "low limit" extracted from whole recordset returned by "sql query". I am using oracle 8i. Attached is what I am tried to do. But I don't know how to complete this procedures. Please help me if you can. -----------------
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Complete ownership and distribution copyrights to all work purchased.
Oracle 8i under Win2k Pro.
## Deadline information
Need this ASAP