i have to execute a create tabel statement in pl/sql which i could do it will
execute immediate statement
but when i execute it give
ORA-01031: insufficient privileges
i gave sysdba privileges also but it is still giving it.
procedure secondproc as
procedure hello as
execute immediate 'create table testvariables(id number,name1 varchar2(12))';
-- execute immediate 'insert into testvariables values (1,''dd'');';
-- htp.ps('In secproc');
-- execute immediate 'select id into a from testvariables';
I have similar kind of problem while creating function based indexs. When I use execute immediate it gives "-1031 ORA-01031: insufficient privileges". What privileges does this need. It creates conventional indexes but not function based indexes. Even create index statement gives the same error.