Is Oracle ODBC support batch SQL(PL/SQL procedure)? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Is Oracle ODBC support batch SQL(PL/SQL procedure)?

Is Oracle ODBC support batch SQL(PL/SQL procedure)?# Database - 数据库

h*r2001-03-09 08:03

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*q2001-03-09 08:03

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.