bind variables and dynamic ref cursors
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 ?Received on Mon May 26 2008 - 17:31:57 CDT