REF CURSOR

Hi,

I may be answering my own question, but I want to make sure.

Say I have a ref cursor that has a dynamic where clase, and in addition a bind variable that changes each time through the loop:

OPEN cust_ref FOR
  'SELECT customer_name, customer_address    FROM customer
   WHERE customer_id = :v_customer_id'
   USING v_customer_id;

My question is, since v_customer_id is a parameter, do I need to close and open the cursor each time that value changes? Or can I just change the value and fetch the next record?

Thanks!

John Received on Tue Jun 17 2008 - 08:47:14 CDT