|HELP : v$session.module [message #181239]
||Fri, 07 July 2006 10:57
Registered: July 2006
I need to identify my application, so i use dbms_application_info.set_module in the POST-LOGON of the principal form of my application, i use :|
this sentence let me identify my application, so if i query the v$session.module in sql, i can see 'MY-APPLICATION' in v$session. This work good !!!
But the problem is, i need to do some restrictions in the POST-LOGON trigger in DATABASE, but this trigger in database start before the post-logon trigger in the form. So when i going to verify in the post-logon in database, the v$session.module is not set yet. This is in blanks or null.
This is the code example :
IN THE FORM
IN POST-LOGON TRIGGER
IN DATABASE LEVEL
CREATE OR REPLACE TRIGGER Check_Restrictions
After Logon ON DATABASE
from v$session S
where audsid = USERENV('sessionid');
if vc_Module <> 'MY-APPLICATION' then
-- Fire the restrictions
The problem is, when my application starts, the after logon trigger in database starts before POST-LOGON trigger in the forms, so the v$session.module is not set yet, so i can not do the restrictions.
I Apreciate your help.