bind variables and dynamic ref cursors

  • From: "Rick Ricky" <ricks12345@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 26 May 2008 18:31:57 -0400

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?

I know how to use dynamic sql. I am not sure how to get this to work with
ref cursors where the number of bind variables vary ?

Other related posts: