各位大佬，test表如下
desc test;
LINEID NAME TYPE$ NULLABLE
1 ID INTEGER N
2 NAME VARCHAR(100 CHAR) Y
id是int auto_increment primary key
disql中下面SQL报错
insert into test(name) values('a'),('b') return id bulk collect into id;
[-5014]:Error in line: 1
Invalid return into object.
used time: 1.428(ms). Execute id is 0.
应该暂时不支持这样写，可以试试这样
试试这样：
INSERT INTO test(name) VALUES('a') RETURN id INTO :v_id1;
INSERT INTO test(name) VALUES('b') RETURN id INTO :v_id2;
或者这样
CREATE SEQUENCE seq_test;
INSERT INTO test(id, name) VALUES(seq_test.NEXTVAL, 'a');
INSERT INTO test(id, name) VALUES(seq_test.NEXTVAL, 'b');