-
hi all,
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
a number;
procedure hello as
begin
execute immediate 'create table testvariables(id number,name1 varchar2(12))';
-- execute immediate 'insert into testvariables values (1,''dd'');';
end;
begin
hello;
-- htp.ps('In secproc');
-- execute immediate 'select id into a from testvariables';
-- htp.ps(a);
htp.ps('hello');
end;
please help
Saurabh Garg
OCP 9i
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|