EXECUTE IMMEDIATE ORA-01031: insufficient privileges

Here is link of this post
EXECUTE IMMEDIATE ORA-01031: insufficient privileges

This site moved to dbacatalog.blogspot.com please visit dbacatalog.blogspot.com

Advertisements

One thought on “EXECUTE IMMEDIATE ORA-01031: insufficient privileges

  1. Guru

    Kindly use the following option ..it will invoke user rights and executes without error.

    create or replace procedure test_proc
    AUTHID CURRENT_USER =====>
    is
    begin
    EXECUTE IMMEDIATE ‘CREATE TABLE TEST1(ID NUMBER)’;
    end;
    /

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s