DROP SEQUENCE CUSTOMERID;
CREATE SEQUENCE CUSTOMERID INCREMENT BY 1 START WITH 100;

INSERT INTO CUSTOMER  (CUSTOMER_ID, NAME,  STATE, Salesperson_Id, Credit_Limit )
SELECT  CUSTOMERID.nextval
	, yy.old_id
        , zz.location_code
        , zz.EMPLOYEE_ID
        , yy.credit_limit
FROM   test_all_orders4 yy JOIN 
       (SELECT e.EMPLOYEE_ID
	 		   , d.LOCATION_ID
               , l.location_code
        FROM   EMPLOYEE e
               , DEPARTMENT d,
               (SELECT location_id, location_code
               FROM    LOCATION JOIN region
               ON sales_region = regional_group) l
        WHERE  e.department_id = d.DEPARTMENT_ID
        AND    d.location_id = l.location_id
        AND    d.NAME = 'SALES'
        AND e.EMPLOYEE_ID IN (SELECT DISTINCT t.MANAGER_ID FROM EMPLOYEE t)) zz
ON SUBSTR(yy.old_id,1,2) = zz.location_code
AND yy.customer_id IS NULL
GROUP BY yy.old_id, yy.credit_limit, zz.EMPLOYEE_ID, zz.location_code;

ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 8
ORA-02287: sequence number not allowed here

INSERT INTO CUSTOMER  (CUSTOMER_ID, NAME,  STATE, Salesperson_Id, Credit_Limit )
SELECT CUSTOMERID.nextval
	     , old_id
       , location_code
       , EMPLOYEE_ID
       , credit_limit
FROM   (SELECT  yy.old_id
                , zz.location_code
                , zz.EMPLOYEE_ID
                , yy.credit_limit
        FROM   test_all_orders4 yy JOIN 
               (SELECT e.EMPLOYEE_ID
        	 		   , d.LOCATION_ID
                       , l.location_code
                FROM   EMPLOYEE e
                       , DEPARTMENT d,
                       (SELECT location_id, location_code
                       FROM    LOCATION JOIN region
                       ON sales_region = regional_group) l
                WHERE  e.department_id = d.DEPARTMENT_ID
                AND    d.location_id = l.location_id
                AND    d.NAME = 'SALES'
                AND e.EMPLOYEE_ID IN (SELECT DISTINCT t.MANAGER_ID FROM EMPLOYEE t)) zz
        ON SUBSTR(yy.old_id,1,2) = zz.location_code
        AND yy.customer_id IS NULL
        GROUP BY yy.old_id, yy.credit_limit, zz.EMPLOYEE_ID, zz.location_code);

SELECT customerid.NEXTVAL,
       old_id,
       location_code,
       employee_id,
       credit_limit
FROM   (SELECT yy.old_id,
               l.location_code,
               e.employee_id,
               yy.credit_limit
        FROM   employee e
        JOIN   test_all_orders4 yy ON  substr(yy.old_id, 1, 2) = l.location_code
                                   AND yy.customer_id IS NULL
        JOIN   department d ON  d.department_id = e.department_id
                            AND d.NAME = 'SALES'
        JOIN   location l ON l.location_id = d.location_id 
        JOIN   region ON sales_region = regional_group
        WHERE  e.employee_id IN (SELECT DISTINCT t.manager_id FROM employee t)
        GROUP  BY yy.old_id, yy.credit_limit, e.employee_id, l.location_code);