Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using EXCUTE IMMEDIATE in PL/SQL
Do you have grant to create table?
Tom
Alexandros Kotsiras, NYC <alexandros_k_at_prodigy.net> wrote in message
news:394D6F73.C4005C54_at_prodigy.net...
> CREATE OR REPLACE PROCEDURE TEST_PROC AS
> begin
> execute immediate 'create table TEST_1 as select * from TEST ' ;
> end;
>
> I receive :
> ORA-01031 Insufficient privileges
>
> Why that ? ?
> I do not have problems with procedures that do not have "execute
> immediate" inside.
> I am the owner of the procedure and the TEST table.
> If i execute the create table statement directly from SQL*Plus it works
> fine ....
>
> The description of the error message in the documentation doesn't really
> help.
>
Received on Mon Jun 19 2000 - 00:00:00 CDT