Forms_ddl question
From: wozi <wozi_at_dhc.net>
Date: Mon, 3 Jan 2000 23:46:30 -0800
Message-ID: <50B052DC210C88B5.D0D73E2D8EE5443A.F643FB59C48FD85D_at_lp.airnews.net>
[Quoted] I place the following code in a button, but it doesn't seem to be working. The same code works when issued from sql*plus - execute sys.dbms_system.set_sql_trace_in_session(7,24,true)
Date: Mon, 3 Jan 2000 23:46:30 -0800
Message-ID: <50B052DC210C88B5.D0D73E2D8EE5443A.F643FB59C48FD85D_at_lp.airnews.net>
[Quoted] I place the following code in a button, but it doesn't seem to be working. The same code works when issued from sql*plus - execute sys.dbms_system.set_sql_trace_in_session(7,24,true)
The 7,24 numbers are actual number for a user logged in at the time the command is issued, so it is valid.
BEGIN
Forms_DDL('execute sys.dbms_system.set_sql_trace_in_session(7,24,true)');
IF NOT Form_Success THEN
Message ('Unable to set trace');
ELSE
Message ('Trace turned on');
END IF;
END;
thanks for your help
Received on Tue Jan 04 2000 - 08:46:30 CET