Toad World® Forums

insufficient privileges to create a function

received [Error] Compilation (1: 1): ORA-01031: insufficient privileges when executing a create or replace function statement.

when the exact same (copy and paste) code with oracle sql developer in the same schema the function was created.

what do I need for this to work in toad?

How are you creating your function? Turn on SQL spooling from the Database menu and try again. Look at the output and locate the offending statement. Depending on execution method Toad executes other statements along with the create. One of those may be failing.

Michael

On 08/26/2015 11:01 AM, Tom wrote:

insufficient privileges to create a function

Thread created by Tom
received [Error] Compilation (1: 1): ORA-01031: insufficient privileges when executing a create or replace function statement.

when the exact same (copy and paste) code with oracle sql developer in the same schema the function was created.

what do I need for this to work in toad?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Thank you, that showed the problem.

From:
Michael Staszewski [mailto:bounce-mstaszew@toadworld.com]

Sent: Wednesday, August 26, 2015 9:37 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] insufficient privileges to create a function

RE: insufficient privileges to create a function

Reply by Michael Staszewski

How are you creating your function? Turn on SQL spooling from the Database menu and try again. Look at the output and locate the offending statement. Depending on execution method Toad executes other statements along with the create. One of those may be failing.

Michael

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Me too, I have the same problem ;/

And I thought I’m the only one with this problem!