Create Table/View aaa ( col1 number(8) not null, constraint pk_aaaa primary key(col1) using index tablespace skysystemindex) tablespace skysystem
CREATE PROCEDURE income(amount number) AUTHID current_user IS c number; n number; BEGIN c:= dbms_sql.open_cursor; dbms_sql.parse(c, 'insert into accts(''income'', :1)', dbms_sql.native); dbms_sql.bind_variable(c, '1', amount); n := dbms_sql.execute(c); dbms_sql.close_cursor(c); END;
楼主,不行哈,我是说在存储过程中创,形如: create or replace sp_b() .... is vA varchar2(100); vb varchar2(100); ..... begin .... create table aa ( col1 varchar2(10), .... ); insert into aa(col1....) values (....); .... end;
....
is
vA varchar2(100);
vb varchar2(100);
.....
begin
....
sp_a(vA ,Vb );
1。创建OCCI环境,,,
2。创建连接
3。创建句柄时参数用“BEGIN PROCNAME(:V1,:V2,.....)END;“
4。设置入参:setString(1,str);
5. 设置出参:registerOutpara(2,outpara,OCCISTRING,sizeof outpara,"")
col1 number(8) not null,
constraint pk_aaaa primary key(col1)
using index
tablespace skysystemindex)
tablespace skysystem
AUTHID current_user IS
c number;
n number;
BEGIN
c:= dbms_sql.open_cursor;
dbms_sql.parse(c, 'insert into accts(''income'', :1)', dbms_sql.native);
dbms_sql.bind_variable(c, '1', amount);
n := dbms_sql.execute(c);
dbms_sql.close_cursor(c);
END;
create or replace sp_b()
....
is
vA varchar2(100);
vb varchar2(100);
.....
begin
....
create table aa (
col1 varchar2(10),
....
);
insert into aa(col1....) values (....);
....
end;
1) 只能是动态SQL;
2)8I以上支持下execute immadite