Bug in 12.1 (enable trigger)

Toad for Oracle
1

Hi

Toad x64 12.1.0.22
DB 11.2.0.3
Win 7 Pro Sp1 x64

When I want to enable trigger and action failed, I get this output:

SQL> ALTER TRIGGER SYS.TGBLOFF$_TEST_TRACE ENABLEALTER TRIGGER SYS.TGBLOFF$_TEST_TRACE ENABLE
Error at line 2
ORA-01031: insufficient privileges
Script Terminated on line 2.

As you see error is written twice.

Brg,

Damir Vadas

2

It’s only written twice in the spool sql output. The “doubled” command is not sent to Oracle. I am guessing that you were not logged in as SYS while you were trying to make changes to this SYS trigger. That’s why you got the error.

This should be fixed in the current beta.

3

@John

Correct. If I were SYS I would not get this error.

:slight_smile: