/* Use of a PL-SQL bloc to perform the Insert (management of LONGS and LOBS etc.) */   
declare cursor myCursor is   
select 	ITEM_ID,
	ITEM_DSC,
	ITEM_PACKAGE,
	ITEM_MARKETING_MANAGER,
	ITEM_BUYER,
	FAMILY_ID,
	FAMILY_DSC,
	CLASS_ID,
	CLASS_DSC,
	TOTAL_PRODUCT_ID,
	TOTAL_PRODUCT_DSC   
	   
from	GLOBAL_SUNOP_DW_TARGET.I$_PRODUCT_DIM  
where	IND_UPDATE = 'I'  
;   
begin   
	/* Loop over the Cursor and execute the insert statement */   
	for aRecord in myCursor loop   
	insert into GLOBAL_SUNOP_DW_TARGET.PRODUCT_DIM  
		(
		ITEM_ID,
		ITEM_DSC,
		ITEM_PACKAGE,
		ITEM_MARKETING_MANAGER,
		ITEM_BUYER,
		FAMILY_ID,
		FAMILY_DSC,
		CLASS_ID,
		CLASS_DSC,
		TOTAL_PRODUCT_ID,
		TOTAL_PRODUCT_DSC  
		 
			)  
		values   
			(
		aRecord.ITEM_ID, 
		aRecord.ITEM_DSC, 
		aRecord.ITEM_PACKAGE, 
		aRecord.ITEM_MARKETING_MANAGER, 
		aRecord.ITEM_BUYER, 
		aRecord.FAMILY_ID, 
		aRecord.FAMILY_DSC, 
		aRecord.CLASS_ID, 
		aRecord.CLASS_DSC, 
		aRecord.TOTAL_PRODUCT_ID, 
		aRecord.TOTAL_PRODUCT_DSC  
		  
		)  
		;  
	end loop;   
end;