I was coding coding in Oracle, when I encounter an issue Declare and syntax, but I don’t know where is it
Error starting at line : 311 in command –
DECLARE
v_commune_id NUMBER;
v_district_id NUMBER;
BEGIN
FOR stress IN (SELECT * FROM tbl_dm_stress) LOOP
BEGIN
-- Xác ??nh ID c?a District
BEGIN
SELECT ID INTO v_district_id
FROM tbl_dm_district
WHERE NAME = stress.DISTRICTS;
EXCEPTION
WHEN NO_DATA_FOUND THEN
INSERT INTO tbl_dm_district (NAME, ACTIVE)
VALUES (stress.DISTRICTS, 1)
RETURNING ID INTO v_district_id;
END;
END;
BEGIN
-- Xác ??nh ID c?a Commune v?i ?i?u ki?n theo tên District
BEGIN
SELECT ID INTO v_commune_id
FROM tbl_dm_commune
WHERE NAME = stress.COMMUNES
AND ID_DISTRICT = v_district_id;
EXCEPTION
WHEN NO_DATA_FOUND THEN
INSERT INTO tbl_dm_commune (NAME, ACTIVE, ID_DISTRICT, ID_PROVINCE, CODE_COMMUNE_WEB)
VALUES (stress.COMMUNES, 1, v_district_id, NULL, NULL)
RETURNING ID INTO v_commune_id;
END;
END;
-- Insert vào b?ng tbl_dm_stress_detail
INSERT INTO tbl_dm_stress_detail (
STRESS_ID, STRESS_NAME, COMMUNE_ID, COMMUNE_NAME, DISTRICT_ID, DISTRICT_NAME,
ACTIVE, CREATE_DATE, CREATE_BY, LAST_UPDATE_DATE, LAST_UPDATE_BY
)
VALUES (
stress.ID, stress.STRESS_NAME, v_commune_id, stress.COMMUNES, v_district_id, stress.DISTRICTS,
1, SYSDATE, stress.CREATE_BY, SYSDATE, stress.LAST_UPDATE_BY
);
END LOOP;
END;
Error report -
ORA-06550: line 37, column 76:
PL/SQL: ORA-00904: "DISTRICT_NAME": invalid identifier
ORA-06550: line 36, column 9:
PL/SQL: SQL Statement ignored
06550. 00000 - "line %s, column %s:n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:
``
Try run to code, exception
Error starting at line : 311 in command -
DECLARE
v_commune_id NUMBER;
v_district_id NUMBER;
and
Error report
ORA-06550: line 37, column 76:
PL/SQL: ORA-00904: “DISTRICT_NAME”: invalid identifier
ORA-06550: line 36, column 9:
PL/SQL: SQL Statement ignored
06550. 00000 – “line %s, column %s:n%s”
*Cause: Usually a PL/SQL compilation error.