DECLARE
    
	F UTL_FILE.FILE_TYPE;
    V_LINE VARCHAR2 (1000);
    V_Name varchar2(512 char);
    V_ParentUID raw(16);
    V_Path varchar2(1024 char);
    V_PrimaryType varchar2(32 char);
    V_SubType varchar2(32 char);
    V_GeneralType number(5,0);
    V_Undeletable number(1,0);
    V_ErrorWarningStatus number(10,0);
    V_ComplianceStatus number(10,0);
    V_Description clob;
	
	
	
	Q UTL_FILE.FILE_TYPE;
    G_LINE VARCHAR2 (1000);
    G_FilterString clob;
    G_LogHistoryCount number(5,0);
   

   
  T UTL_FILE.FILE_TYPE;
    X_LINE VARCHAR2 (1000);
    X_contextid raw(16);
    X_position number(10,0);
	
	
  folderUID raw(16);
  
  o_zuid folderUID%type;
  
  BEGIN
	
	
  F := UTL_FILE.FOPEN ('SOU', 'zenobject.csv', 'R');
	Q := UTL_FILE.FOPEN ('SOU', 'querygroup.csv', 'R');
	T := UTL_FILE.FOPEN ('SOU', 'querycontext.csv', 'R');
    IF UTL_FILE.IS_OPEN(F) AND UTL_FILE.IS_OPEN(Q) AND UTL_FILE.IS_OPEN(T) THEN
      LOOP
        BEGIN
          UTL_FILE.GET_LINE(F, V_LINE, 1000);
           UTL_FILE.GET_LINE(Q, G_LINE, 1000);
           UTL_FILE.GET_LINE(T, X_LINE, 1000);
          IF V_LINE IS NULL THEN
            EXIT;
          END IF;
          IF G_LINE IS NULL THEN
            EXIT;
          END IF;
          IF X_LINE IS NULL THEN
            EXIT;
          END IF;
          V_Name := REGEXP_SUBSTR(V_LINE, '[^,]+', 1, 1);
          V_ParentUID := REGEXP_SUBSTR(V_LINE, '[^,]+', 1, 2);
          V_Path := REGEXP_SUBSTR(V_LINE, '[^,]+', 1, 3);
          V_PrimaryType := REGEXP_SUBSTR(V_LINE, '[^,]+', 1, 4);
          V_SubType := REGEXP_SUBSTR(V_LINE, '[^,]+', 1, 5);
          V_GeneralType := REGEXP_SUBSTR(V_LINE, '[^,]+', 1, 6);
          V_Undeletable := REGEXP_SUBSTR(V_LINE, '[^,]+', 1, 7);
          V_ErrorWarningStatus := REGEXP_SUBSTR(V_LINE, '[^,]+', 1, 8);
          V_ComplianceStatus := REGEXP_SUBSTR(V_LINE, '[^,]+', 1, 9);
          V_Description := REGEXP_SUBSTR(V_LINE, '[^,]+', 1, 10);
		  
          G_LogHistoryCount := REGEXP_SUBSTR(G_LINE, '[^,]+', 1, 1);
          G_FilterString := REGEXP_SUBSTR(G_LINE, '[^,]+', 1, 2);
          
      
          X_contextid := REGEXP_SUBSTR(X_LINE, '[^,]+', 1, 1);
          X_position := REGEXP_SUBSTR(X_LINE, '[^,]+', 1, 2);
       
     
      folderUID := sys_guid();
       
			INSERT INTO zob VALUES(folderUID, V_Name, V_ParentUID, V_Path, V_PrimaryType, V_SubType, V_GeneralType, V_Undeletable, V_ErrorWarningStatus, V_ComplianceStatus, V_Description)
			returning folderUID into o_zuid;
		
			INSERT INTO zqg VALUES(o_zuid, G_LogHistoryCount, G_FilterString);
			INSERT INTO zctx VALUES(o_zuid, X_contextid, X_position);
      COMMIT;
        EXCEPTION
        WHEN NO_DATA_FOUND THEN
          EXIT;
        END;
      END LOOP;
    END IF;
    UTL_FILE.FCLOSE(F);
  	UTL_FILE.FCLOSE(Q);
  	UTL_FILE.FCLOSE(T);
	
END;

      
			INSERT INTO zob VALUES(folderUID, V_Name, V_ParentUID, V_Path, V_PrimaryType, V_SubType, V_GeneralType, V_Undeletable, V_ErrorWarningStatus, V_ComplianceStatus, V_Description)
			returning folderUID into o_zuid;
		
			INSERT INTO zqg VALUES(o_zuid, G_LogHistoryCount, G_FilterString);
			INSERT INTO zctx VALUES(o_zuid, X_contextid, X_position);