How To select limited number of rows from procedure out cursor

i开发者_StackOverflow中文版 have a cursor out from a procedure..and i want to fetch particular rows.. i.e, i want to use where condition in that out cursor..can we do the same in PL/SQL develover 10g

Once the cursor has been opened, its result set is determined, so you cannot filter it then. If you cannot have the required filter added into the procedure definition then you are going to have to fetch all the rows and filter them in your code.