i want to know if exists any query or something that tell me what object are running a package(trigger, procedure,....).
i was trying to audit a procedure that sometimes fails, but only get the sql_text and the values it got (sql_bind) from dba_audit_trail, but know i want to know what is running it or using is?