bind variables and dynamic ref cursors

From: Rick Ricky <ricks12345_at_gmail.com>
Date: Mon, 26 May 2008 18:31:57 -0400
Message-ID: <81f4c0700805261531v32d6d89p225ee2cf9dff7e87@mail.gmail.com>


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 ?

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 26 2008 - 17:31:57 CDT

Original text of this message