Privs acquired via ROLE do NOT apply within PL/SQL procedures. Have the necessary GRANT(s) been issued? On 8/6/05, Arul Ramachandran <contactarul@xxxxxxxxx> wrote: > Hi all: > > This is on Oracle10G R1 / Windows-XP Pro. > > I am trying to trace a simple stored procedure that does DMLs, with a > 'execute immediate' that set events 10046 trace. When I execute the > procedure from sqlplus, I am able to see the trace in user_dump destination > as expected. -- //www.freelists.org/webpage/oracle-l