使用occi如何实现执行一个多行的sql语句？？

[ralln]

数据库是oracle 11g
sql: create table aa(num1 number not null,num2 number not null);create table bb(num1 number not null,num2 number not null);


比如我定义个string str = "create table aa(num1 number not null,num2 number not null);create table bb(num1 number not null,num2 number not null);"

执行会报错，网上查了下提示要去掉分号，不过去掉分号又不能执行

请问该怎么办？

[yuppy]

string str = "execute immediate 'create table aa(num1 number not null,num2 number not null);create table bb(num1 number not null,num2 number not null);' " 这样试试

[wangchangming]

string str = "begin execute immediate 'create table aa(num1 number not null,num2 number not null)'; execute immediate 'create table bb(num1 number not null,num2 number not null)'; end;";