原来的SQL:
INSERT INTO TEST(STATUS, BODY) VALUES('complete', RPAD('*', 4000, '*') || RPAD('*', 4000, '*'));
更改为declare语句:
DECLARE v_sql CLOB;
BEGIN
v_sql := RPAD('*', 4000, '*') || RPAD('*', 4000, '*');
INSERT INTO TEST(STATUS, BODY) VALUES('complete', v_sql);
COMMIT;
END;