SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01031: insufficient privileges while issuing an EXECUTE IMMEDIATE

Naru72Feb 14 2012 — edited Feb 16 2012

Hi there,

I am trying to issue an EXECUTE IMMEDIATE command from within a PL/SQL procedure and I get the above error. What is puzzling is that the same EXECUTE IMMEDIATE command works from within an anonymous PL/SQL block. The procedure and the anonymous block both are run as the same user, so it cannot be a privileges/permissions issue.

Wondering if anybody out there has faced a similar issue, and if so, any pointers would be highly appreciated.

Many thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 15 2012

Added on Feb 14 2012

10 comments

9,470 views