Re: trigger problem

>| But what is so special about Toad that it alone should be banned? What
>| can a developer do to the production database with Toad that he/she
>| could not do with SQL Plus, Forms, HTMLDB, or any one of dozens of
>| other ways to access the database?
>|
>
> Why do i often see huge sql taking hours and consuming all CPU resources
> with TOAD and not with SQL*Plus? Maybe because it is so easy to generate
> awful statements with TOAD and you think a little bit before writing a query
> in SQL*Plus.

In that case, create a profile where you limit CPU usage (for example cpu_per_session) and assing this profile to the offending user.

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/