问题
我写了一段自动插入数据的SQL，但是报错了我找不到问题
DECLARE
i NUMBER := 101;
yn NUMBER;
xn NUMBER;
customs DBMS_SQL.VARCHAR2S := DBMS_SQL.VARCHAR2S(
‘会展海关’, ‘保税区海关’, ‘保税区海关’, ‘其他2211’,
‘其他2214’, ‘其他2242’, ‘吴淞海关’, ‘嘉定海关’,
‘嘉定海关’, ‘外港海关’, ‘奉贤海关’, ‘奉贤海关’,
‘宝山海关’, ‘崇明海关’, ‘徐汇海关’, ‘杨浦海关’,
‘松江海关’, ‘松江海关’, ‘松江海关’, ‘洋山海关’,
‘洋山海关’, ‘洋山海关’, ‘洋山海关’, ‘浦东机场海关’,
‘浦东机场海关’, ‘浦东机场海关’, ‘浦东机场海关’, ‘浦东海关’,
‘浦东海关’, ‘浦东海关’, ‘浦江海关’, ‘浦江海关’,
‘浦江海关’, ‘浦江海关’, ‘科创海关’, ‘莘庄海关’,
‘莘庄海关’, ‘莘庄海关’, ‘虹口海关’, ‘虹桥机场海关’,
‘车站海关’, ‘车站海关’, ‘车站海关’, ‘邮局海关’,
‘金山海关’, ‘金山海关’, ‘钻交所海关’
);
ports DBMS_SQL.VARCHAR2S := DBMS_SQL.VARCHAR2S(
‘沪会展关’, ‘外高桥关’, ‘保税物流’, ‘卢湾监管’,
‘漕河泾发’, ‘沪业二处’, ‘吴淞海关’, ‘嘉定海关’,
‘嘉定出口’, ‘外港海关’, ‘奉贤海关’, ‘奉贤综保’,
‘宝山海关’, ‘崇明海关’, ‘沪徐汇关’, ‘沪杨浦关’,
‘松江综B’, ‘松江海关’, ‘松江综A’, ‘洋山港区’,
‘洋山芦潮’, ‘洋山海关’, ‘洋山特综’, ‘上海快件’,
‘沪空港办’, ‘浦东机场’, ‘浦机综保’, ‘金桥综保’,
‘浦东海关’, ‘沪金桥办’, ‘洋山市内’, ‘航交办’,
‘浦江海关’, ‘贸易网点’, ‘沪科创关’, ‘虹桥B保’,
‘莘庄海关’, ‘闵开发区’, ‘沪虹口关’, ‘虹桥机场’,
‘车站海关’, ‘西北物流’, ‘普陀区站’, ‘邮局海关’,
‘金山海关’, ‘沪化工区’, ‘沪钻交所’
);
BEGIN
WHILE i <= 102 LOOP
yn := ROUND(DBMS_RANDOM.VALUE(0,1)); – 0 或 1 随机数
INSERT INTO “DW_TGSX”.“DW_TRADE_ENTRY_DETAIL” VALUES (
i,
‘I’,
‘1’,
‘1’,
‘1’,
‘1’,
‘2’,
‘2237’,
‘浦东机场海关’,
‘浦机综保’,
‘2245’,
‘22’,
‘1’,
‘1’,
‘1’,
‘1’,
‘1’,
‘1’,
‘1’,
‘1’,
‘1’,
‘1’,
‘1’,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
TO_DATE(‘2023-04-28 16:20:54’, ‘YYYY-MM-DD HH24:MI:SS’),
TO_DATE(‘2023-04-27 16:26:57’, ‘YYYY-MM-DD HH24:MI:SS’),
‘1’,
NULL,
‘1’,
‘1’,
‘1’,
‘1’,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
‘1’,
‘1’,
‘1’,
‘1’,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
‘1’,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
TO_DATE(‘2023-04-13 16:23:27’, ‘YYYY-MM-DD HH24:MI:SS’),
TO_DATE(‘2023-04-13 16:26:26’, ‘YYYY-MM-DD HH24:MI:SS’),
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
‘5’,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
CASE WHEN yn = 1 THEN ‘Y’ ELSE ‘N’ END,
TO_TIMESTAMP(’ 2023-04-28 16:24:26:000000’, ‘YYYY-MM-DD HH24:MI:SS:FF6’),
TO_TIMESTAMP(’ 2023-04-28 16:24:30:000000’, ‘YYYY-MM-DD HH24:MI:SS:FF6’)
);
i := i + 1;
END LOOP;
END;
报错信息
[Err] ORA-06550: line 6, column 7:
PLS-00681: named association syntax is required
ORA-06550: line 5, column 12:
PL/SQL: Item ignored
ORA-06550: line 20, column 7:
PLS-00681: named association syntax is required
ORA-06550: line 19, column 10:
PL/SQL: Item ignored