ORA-01031 in execution of procedure with DBMS_UTILITY.EXEC_DDL_STATEMENT

Hi,

I would like to know why i have the error ORA-01031 when i execute the procedure.

createquery='create table xxxx as (select * from yyyy where a=b)' DBMS_OUTPUT.PUT_LINE(createquery)
DBMS_UTILITY.EXEC_DDL_STATEMENT(createquery)

SQL>set serveroutput on
SQL>exex proc1
create table xxxx as (select * from yyyy where a=b)

ORA-01031 : insuficients privileges

but, when i execute this command (create table xxxx), there is no problem. Is it a privilege on the package? No! i grant execute on this package to my user.

Can anybody could explain me what i have done wrong???

Cheers.

Fly Received on Mon Jan 14 2002 - 11:13:03 CST