Re: ora -1031 - Why???

This is Roles. Roles are not enabled during execution of a procedure. As an anonymous pl/sql block is a one-time operation (from the perspective of the database) roles *are* enabled during execution of anonymous blocks. In Oracle 8i you have the option of defining the procedure with invokers rights instead of with definers rights (Oracle 7 and 8.0 behavior).

Hth,

Sybrand Bakker, Oracle DBA

Kenneth C Stahl <BlueSax_at_Unforgettable.com> schreef in berichtnieuws 3925896A.82409182_at_Unforgettable.com...
> I have a pl/sql procedure which uses dbms_sql to rebuild some indexes.
> If I run it from within sqlplus it runs fine. But, if I change the first
> line from 'declare' to 'create or replace rebuildindexes as', it will
> compile correctly but when it runs it generates an ORA-1031 error. The
> user that I am running this has 'execute any procedure'. I've looked at
> the messages manual and it really doesn't help. Does anyone know what it
> going on?
Received on Fri May 19 2000 - 00:00:00 CDT