create or replace search_entry_in_subfolders (
	p_root_id	 IN searchresult.tocid%type,
	p_rsid		 IN searchresult.rsid%type,
	p_table_name IN varchar2,
	p_num_inserted OUT number)
as
	v_table      VARCHAR2(30);
	v_root_id    VARCHAR2(10);
	v_rsid       VARCHAR2(10);
begin
	select object_name into v_table
	from USER_OBJECTS
	where object_name = upper(p_table_name) and OBJECT_TYPE = 'TABLE';

	select cast(p_rsid as varchar2(10)) into v_rsid from dual;
	select cast(p_root_id as varchar2(10)) into v_root_id from dual;

	execute immediate  'insert into ' || v_table ||
'(tocid, rsid, hitcount, parentid, etype, acl_tocid, vol_id, path)
select tocid, ' || v_rsid || ', 0, parentid, etype, acl_tocid, vol_id, ''''
from toc where parentid in (select toc.tocid from toc
start with tocid = ' || v_root_id ||
'connect by parentid = prior tocid)';

	p_num_inserted := sql%rowcount;
end search_entry_in_subfolders;