Re: trace every SQL statement of a specific user

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Thu, 6 Mar 2008 05:17:33 -0800 (PST)
Message-ID: <88cd505a-0126-4de4-9e79-fbf63e75979e@60g2000hsy.googlegroups.com>

semicolon was lost after defining variable v.

CREATE OR REPLACE TRIGGER on_logon
AFTER LOGON
on gints.schema
declare
� v varchar2 (100) := 'alter session set events ''10046 trace name
context forever, level 12''';
begin
� execute immediate v;

end;
/