February 2nd, 2004, 12:56 AM
Join Date: Sep 2003
Time spent in forums: 1 Day 10 h 14 m 25 sec
Reputation Power: 11
tough time with cursors
I am getting an error to which I am sure is because of a subquery within a cursor declaration. That may sound way wacked out to someone who knows what they are doing, but I was told that you cannot have a variable that hasn't been set yet in the cursor declaration, so I wasn't sure on another way to do it.
Here is the code.
cursor c_rentalInvoices is
select rid.invoice_number, rid.date_returned
from rental_invoices ri, rental_invoice_details rid
ri. member_number = Select member_number From members Where last_name = p_lastName AND first_name = p_firstName
ri. invoice_number = rid.invoice_number;
Thanks for any help that you can give me