Get "ORA-01031: Insufficient Privileges" when running a query as script, but not as statement. (4239245)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Get "ORA-01031: Insufficient Privileges" when running a query as script, but not as statement.
Description

When running a query as a script (F5), an "ORA-01031: Insufficient Privileges" message appears. However, if the exact same query is run as a statement (F9), it runs fine. Both runs are done in the same schema in the same session.
Resolution

WORKAROUND:
None

STATUS:
Issue fixed in version 9.5. The latest version of Toad for Oracle can be downloaded here.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title