Store Procedure Help

From: Aaron Rouse <aaron_rouse_at_yahoo.com>
Date: 9 Jan 2003 14:51:55 -0800
Message-ID: <a57b6daf.0301091451.24d3b8b6@posting.google.com>

I am trying to create a pretty simple stored procedure but when I try to add my incrementing value I get errors on the = sign in the compile process. What I need to do is insert the CD_SYSKEY_NEXT value I pull from TMS_SYSKEY into my SLB_ABR_TEST table and then increment that by one for each loop instance then insert the last value into the TMS_SYSKEY table for future use. However I am to the point below and am unsure how to correct it and move on with the procedure:

CREATE OR REPLACE procedure SP_SLB_TEST AS

	   CURSOR LOC IS
	   		   SELECT CD_LOC, NM_LST_UPDT, DT_LST_UPDT, CD_SEG FROM

LOCATIONS WHERE CD_LOC NOT IN (SELECT CD_LOC FROM LOCATIONS_DTL);

	   CURSOR NEWID IS
	   		  SELECT MAX(CD_SYSKEY_NEXT) AS LOC_ID FROM TMS_SYSKEY WHERE

NM_TABLE = 'LOCATIONS_DTL';                     loopLOC_ID NUMBER(3);            

           loopLOC_ID := NEWID.LOC_ID;         

	   BEGIN
	   		FOR i IN LOC LOOP


				-- loopLOC_ID would be inserted into ID_LOC

				-- Insert in LOCATIONS_DTL

				INSERT INTO SLB_ABR_TEST 
				(CD_LOC, NM_LST_UPDT, DT_LST_UPDT, CD_SEG)
				VALUES
				(i.CD_LOC, i.NM_LST_UPDT, i.DT_LST_UPDT, i.CD_SEG);


				-- loopLOC_ID := loopLOC_ID + 1;

			COMMIT;
			END LOOP;
			-- Need to insert the loopLOC_ID into TMS_SYSKEY

END SP_SLB_TEST; Received on Thu Jan 09 2003 - 16:51:55 CST