JAVA SOURCE: SYS.dbFWTrace

Source

1 import oracle.scheduler.agent.fileWatchTrace;
2 import oracle.jdbc.*;
3 import oracle.jdbc.pool.OracleDataSource;
4 import java.sql.Connection;
5 
6 public class dbFWTrace implements fileWatchTrace
7 {
8   public void writeTrace(String do_trc, String trc_string)
9   {
10     if (do_trc.equals("Y"))
11     {
12       try
13       {
14         OracleDataSource ods = new OracleDataSource();
15         ods.setURL("jdbc:default:connection");
16         Connection conn = ods.getConnection();
17         OracleCallableStatement ocs = (OracleCallableStatement)conn.prepareCall(
18             "{call dbms_isched.write_file_watch_trace(?, ?)}");
19         ocs.setString(1, do_trc);
20         ocs.setString(2, trc_string);
21         ocs.executeUpdate();
22         ocs.close();
23       }
24       catch (java.sql.SQLException sqlexception)
25       {
26         // ignore for now
27       }
28     }
29   }
30 }