h****r
发帖数: 2056 | 1 Try to use batch SQL like
"begin
insert into table1 values('0', 0);
insert into table1 values('1', 1);
end /"
it works fine in SQLPLUS as a SQL statment,
but use it in ODBC programming it will not works fine,
any shrimps has experiences on it, please share your
idea, thanks a lot. | z*q
发帖数: 29 | 2 As I know, to use batch insert/update, you should use
record/collection/table_of_record type in PL/SQL, just like the following:
forall i in tbl_interval_meter.first .. tbl_interval_meter.last
INSERT INTO interval_meter_temp VALUES tbl_interval_meter (i);
Your begin end code will work in PL/SQL, but is not a batch sql, it is just a
block in PL/SQL.
Hope it is useful.
【在 h****r 的大作中提到】
: Try to use batch SQL like
: "begin
: insert into table1 values('0', 0);
: insert into table1 values('1', 1);
: end /"
: it works fine in SQLPLUS as a SQL statment,
: but use it in ODBC programming it will not works fine,
: any shrimps has experiences on it, please share your
: idea, thanks a lot.
|
|
