Database Trigger
Hello All,
I am trying to create a log on trigger based on module. This is a band aid fix till we can find the performance issue with EF Scaffolding.
Oracle 19.25 cdb/pdb
This works but doesnt satisfy the need for other users
CREATE OR REPLACE TRIGGER OPTIMIZER_FEATURES_TRIGGER
AFTER LOGON
ON DATABASE
BEGIN
/*
This trigger was put in place to assist with EF Core dynamic sql
*/
IF USER IN ('TEST_USER')
THEN
EXECUTE IMMEDIATE 'alter session set optimizer_features_enable=''11.2.0.4''';
END IF;
END;
/
SHOW ERRORS;
I need something like belwo
CREATE OR REPLACE TRIGGER OPTIMIZER_FEATURES_TRIGGER_EF_EXE