Find object owner when more than one have same name
Posted on 2003-11-24
Within a trigger, I want to know what schema the trigger lives in. The thing is I have the same trigger living in several different schemas, all with the same name. So doing a select off of dba_objects won't get me anywhere b/c the "object_name" column isn't a unique identifier. I.e.:
-- USR_TRG --
schemaName := ?
-- do something with the schema name now
Any ideas on how to uniquely identify the trigger and its owner?