Re: ENABLE SQL TRACING FOR A PARTICULAR SESSION
Ok, so you want us to be serious. So you first tell us how this piece of your code could be compiled:
Originally posted by Chuck
Only comments from serious people.
?????? What's that else part there for? Shouldn't be inside IF_ENDIF part? So much about your seriousnes...
if (v_program = 'EXCEL.EXE') then
-- blah blah
And then moving on... You have a select statement with a predicate "... program='EXCEL.EXE'". So what do you think which values will ever be in your variable v_program? Will it ever contain anything else than 'EXCEL.EXE'? No, it won't. So why on earth is there IF statement that check for a condition "if (v_program = 'EXCEL.EXE') then... "??? It will allways be true!
And then most crutial thing in your trigger. You perform SELECT INTO statement without handling NO_DATA_FOUND exception! You are lucky your trigger didn't get compiled at all, because if it were, noone will be able to connect to your database if his/here program weren't called 'EXCEL.EXE'!
If you realy created the trigger with the code you presented here, then it's obvious that it is in INVALID state and is not firing at all. So it's not the trigger that is causing tracing of all session, it must be your system settings that are doing it.
So I think its time for you to get serious...
Last edited by jmodic; 03-16-2004 at 02:00 AM.
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
I dont think exec blah works neither!
That is one of the most interesting threads that I have ever read in this group :-)
I liked the statement:
"The logon trigger which I posted earlier has been compiled succesfully."
Congratulations Chuck! Did you use "COMPILE TRIGGER xxx FORCE COMPILE;"?
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g
Click Here to Expand Forum to Full Width