楼主,不行哈,我是说在存储过程中创,形如:
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;
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;