Permissions problem using DBMS_SQL Package

Can anyone help please???

I've compiled my own package procedure CREATE_COPY_TABLE containing a call to DBMS_SQL.PARSE. The statement being parsed is CREATE TABLE fred AS SELECT * FROM joe - i.e. making a copy of table joe. I've then written a second, anonymous block which calls my procedure, and run it from the same userid that created the procedure, but when I run it I get:

ORA-01031: insufficient privileges

Everything is using the same userID and I can execute the exact same 'ceate table' statement directly from SQL*Plus without problems, so why doesn't it work as part of the procedure?
Can anyone explain this mystery to me please and how I can solve it? Thanks.
(PS. It's Personal Oracle 8.0.4 on Windows 98. The user ID has Connect, Resource and DBA privileges.) Received on Sun Oct 17 1999 - 17:32:03 CDT