Re: The code doesn't work in the package

Sorry, this is perfectly normal and makes sense when you understand the security implications.

May I suggest the Concepts manual at tahiti.oracle.com?

Also, if you go take a look at www.orafaq.com you will find an answer to this question, and being the lazy DBA that I am, it will save me some typing.

Jared

On Sunday 16 December 2001 09:35, Csillag Zsolt wrote:
> 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 ;
>
>
> end ;

Content-Type: text/html; charset="us-ascii"; name="Attachment: 1"
Content-Transfer-Encoding: 7bit
Content-Description: 
----------------------------------------

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).