Monday, May 16, 2011

How to Enable SQL_TRACE in oracle Forms developer ?

How to Enable SQL_TRACE in oracle Forms developer ? 
--------------------------------------------------  
In order to enable a Forms session level SQL_TRACE do the following:   
Place the following line of code in a When-New-Form-Instance Trigger in  
the first form that is run in your application:       
FORMS_DDL('ALTER SESSION SET SQL_TRACE=TRUE');  
A trace file will be generated on the database server in the directory  specified 
by the database parameter user_dump_dest.

No comments: