Re: QUESTION: raise_application_error results in ORA-00604...?

>You should test the call. In a database logon trigger even small 1/100
>of a second advantages are important when you consider how many total
>logon per day take place.

Oh, I quite agree. And thanks for that, because it prompts another thought:

Given that it's only this 'browse_id' schema that is at issue here, I wonder if I should create a schema-specific logon trigger instead. It would certainly reduce the number of times the trigger fires, and given that the number of people who use this specific ID numbers approximately a dozen, it might be wiser than a global database trigger. A full-on database-wide logon trigger does kind of seem wasteful in this case.

Regardless. Yes, testing is always a smart thing to do. ;-))

Cheers,

BD. Received on Thu May 25 2006 - 20:12:28 CDT