Re: 10046 trace in dbms_job
- From: sol beach <sol.beach@xxxxxxxxx>
- To: contactarul@xxxxxxxxx
- Date: Sat, 6 Aug 2005 16:39:19 -0700
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
Other related posts:
