CODEWITHSUNDEEP
plsql
Avi
Avi

Reputation: 1145

How To select limited number of rows from procedure out cursor

i 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

Upvotes: 0

Views: 630

Answers (1)

Tony Andrews
Tony Andrews

Reputation: 132630

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.

Upvotes: 1

Related Questions