Re: Forms_ddl question
Date: Tue, 4 Jan 2000 08:33:36 +0100
Message-ID: <84s7q8$dvm$1_at_talia.mad.ttd.net>
Hello,
I think you do not have to write execute, I think you can do one of the two
next sentences:
1. Forms_DDL('dbms_system.set_sql_trace_in_session(7, 24, true)');
2. Forms_DDL('begin dbms_system.set_sql_trace_in_session(7, 24, true);
end;');
wozi escribió en mensaje
<50B052DC210C88B5.D0D73E2D8EE5443A.F643FB59C48FD85D_at_lp.airnews.net>...
>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:33:36 CET