创建存储过程,中使用动态sql建表,报错:
ERROR at line 1:
ORA-01031: insufficient privileges----------------------没有权限
ORA-06512: at "DL0803.KKS_TEST", line 3
ORA-06512: at line 1源代码如下:
create or replace procedure kks_test
is
begin
execute immediate 'create table test_proc( login_name varchar2(10))';
end;运行时没报sql语法错误
ERROR at line 1:
ORA-01031: insufficient privileges----------------------没有权限
ORA-06512: at "DL0803.KKS_TEST", line 3
ORA-06512: at line 1源代码如下:
create or replace procedure kks_test
is
begin
execute immediate 'create table test_proc( login_name varchar2(10))';
end;运行时没报sql语法错误
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货