Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sys_context module problem

688463Jun 12 2009 — edited Jun 15 2009
I have a problem, trigger has been created but

SELECT sys_context('USERENV', 'MODULE') FROM dual;
this above query is showing blank.

I dont have much knowledge about dbms_application_info please help.

Trigger:

CREATE OR REPLACE TRIGGER afterlogon
AFTER LOGON on DATABASE
BEGIN
IF upper(substr(sys_context(''userenv'',''module''),1,3)) ='SQL' THEN
RAISE_APPLICATION_ERROR (-20001, 'You are not allowed using this application');
END IF;
END;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 13 2009
Added on Jun 12 2009
6 comments
770 views