| Error 0RA01031 [message #302] |
Mon, 04 February 2002 07:25  |
INTROV -help
Messages: 1
Registered: February 2002
|
Junior Member |
|
|
I am running this procedure after compilation and gets insufficient privileges errors.
create or replace procedure create_test_tab as
v_sql_stmt varchar2(2000);
v_cnt number;
begin
v_sql_stmt := 'create table test_tab(
x number,
y number,
a varchar2(20))';
execute immediate v_sql_stmt;
for v_cnt in 1..5
loop
v_sql_stmt := 'insert into test_tab
values(:1, :2, :3)';
execute immediate v_sql_stmt
using v_cnt,v_cnt + 1.0, 'a'||to_char(v_cnt);
end loop;
commit;
end;
/
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "INTROV.CREATE_TEST_TAB", line 10
ORA-06512: at line 1
What privileges do we need in order to execute the above procedure.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
