Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> The code doesn't work in the package
Hi,
The following code work as you can see below, but if I put this
code in a package ( a procedure in a package) then I got
ORA-01031 insufficient privileges error.
This is absurd for me because it's the same user (an administrator)
that
owns the package, tablespace, table and everything.
From a pl/sql block it works perfectly with the same user.
Declare
Command
VarChar2(1000)
;
Begin
Command := 'create
table PROBA1
(
PROBA1_1 NUMBER,
PROBA1_2 VARCHAR2(50)
)
tablespace XXX
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K minextents 1 maxextents unlimited
Execute Immediate Command ;