Re: Need help with first Procedure

From: <edwards_at_>
Date: 1997/11/14
Message-ID: <64hj39$j4h@news1.infoave.net>#1/1

> UPDATE address_associations
> SET rec_add_assoc.section_number = v_page,
> rec_add_assoc.page_number = v_listing,
> rec_add_assoc.listing_number = v_section
> WHERE CURRENT OF c_add_assoc;
>

Hello Kelly,

        Looks like the problem is in your update statement. You have prefixed the columns with the cursor name. In this context pl/sql thinks rec_add_assoc is a table name and cant resolve it. Also it looks like you are setting the section_number to the page_number. Anyway, try this

		UPDATE address_associations
		SET section_number = v_section,
		page_number = v_page,
		listing_number = v_listing
		WHERE CURRENT OF c_add_assoc;

-- 

-Steve Edwards
-SCDNR Received on Fri Nov 14 1997 - 00:00:00 CST