 	end;
 	/
 sho err;
+
+CREATE OR REPLACE PROCEDURE proc_hierac_tax_noclass IS
+begin
+
+
+	 -- first get tid and DATASET_ID of inserted_term records
+	for r in (
+		select distinct
+			hierarchical_taxonomy.tid,
+			hierarchical_taxonomy.DATASET_ID,
+			htax_dataset.source,
+			htax_temp_hierarcicized.TAXON_NAME_ID
+		from
+			htax_temp_hierarcicized,
+			htax_seed,
+			htax_dataset,
+			hierarchical_taxonomy
+		where
+			htax_temp_hierarcicized.status='inserted_term' and
+			htax_temp_hierarcicized.TAXON_NAME_ID=htax_seed.TAXON_NAME_ID and
+			htax_temp_hierarcicized.DATASET_ID=htax_seed.DATASET_ID and
+			htax_seed.SCIENTIFIC_NAME=hierarchical_taxonomy.TERM and
+			htax_seed.DATASET_ID = hierarchical_taxonomy.DATASET_ID and
+			htax_seed.DATASET_ID = htax_dataset.DATASET_ID and
+			rownum < 10000
+	) loop
+		--dbms_output.put_line(r.tid || '=>' || r.TAXON_NAME_ID);
+		-- now get terms from Arctos
+		for t in (
+			select
+				term,
+				TERM_TYPE
+			from
+				taxon_term
+			where
+				TAXON_NAME_ID=r.TAXON_NAME_ID and
+				source=r.source and
+				POSITION_IN_CLASSIFICATION is null
+		) loop
+			--dbms_output.put_line('-----' || t.term || '=' || t.TERM_TYPE);
+			insert into  htax_noclassterm (
+				nc_tid,
+				tid,
+				term_type,
+				term_value
+			) values (
+				somerandomsequence.nextval,
+				r.tid,
+				t.TERM_TYPE,
+				t.term
+			);
+		end loop;
+		update htax_temp_hierarcicized set status='inserted_noclassterm' where TAXON_NAME_ID=r.TAXON_NAME_ID and DATASET_ID=r.DATASET_ID;
+	end loop;
+end;
+/
+sho err;
+
+
+
+
+exec proc_hierac_tax_noclass
+
+
+
 
 exec proc_hierac_tax;
 



	-- status does stuff, so...
	alter table htax_dataset add constraint ck_htax_dataset_status
   	CHECK (status IN(
		'working',
		'process_to_bulkloader'
		)
	);


	ALTER TABLE htax_dataset ADD PRIMARY KEY (dataset_id);

				performSearch();
			});
		});
		// end ready function


		function performSearch(){
