Tracing Script

Dear All,

We are executing a procedure and trigger to turn on the database tracing for an application. The Procedure is getting created but the parameters are not being set. Below is the Procedure and triggers.

 CREATE OR REPLACE PROCEDURE set_sql_trace_at_logon(

p_username IN VARCHAR2

DEFAULT SYS_CONTEXT('userenv', 'session_user'),

p_module IN VARCHAR2 DEFAULT SYS_CONTEXT('userenv', 'module')

)

AS

BEGIN

IF ( p_username = 'TESTOWNER' and p_module like 'JDBC%')

THEN

    EXECUTE IMMEDIATE 'alter session set timed_statistics=TRUE';

    EXECUTE IMMEDIATE 'alter session set SQL_TRACE=TRUE';

    EXECUTE IMMEDIATE 'alter session set max_dump_file_size = unlimited';