Re: bind variables and dynamic ref cursors

  • From: "Gints Plivna" <gints.plivna@xxxxxxxxx>
  • To: ricks12345@xxxxxxxxx
  • Date: Tue, 27 May 2008 10:39:48 +0300

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


Other related posts: