See this thread for discussion of various approaches: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1288401763279 Gints Plivna http://www.gplivna.eu 2008/5/27, Rick Ricky <ricks12345@xxxxxxxxx>: > I am writing stored procedures that return ref cursors to developers. For > one query they have the option to send me 2 or 3 parameters. So this means I > need 2 or 3 where clauses. using a dynamic ref cursor, how do i use 2 or 3 > bind variables since the number of where cols = statements will vary? -- //www.freelists.org/webpage/oracle-l