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:
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
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!