bind variables and dynamic ref cursors

From: Rick Ricky <>
Date: Mon, 26 May 2008 18:31:57 -0400
Message-ID: <>

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 ?

Received on Mon May 26 2008 - 17:31:57 CDT

Original text of this message