You Asked
We have a trigger
CREATE OR REPLACE TRIGGER TRG_AFTER_LOGON
AFTER LOGON ON DATABASE
BEGIN
LogonCheck;
END;
/
with
CREATE OR REPLACE PROCEDURE LogonCheck
AUTHID current_user
AS
BEGIN
EXECUTE IMMEDIATE 'SET ROLE NONE';
END;
/
This always results in error ORA-06565, if LogonCheck is called out of the trigger.
LogonCheck succeeds, if called directly.
Obviously the trigger acts as DR unit, which is not allowed in the call stack, if SET ROLE is invoked.
Is there any way to call SET ROLE NONE from out of a trigger?
------------
version
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for 64-bit Windows: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
and Connor said...
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment