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
