ITPub博客

如何在Oracle EBS的PL/SQL Procedure中增加自己的Debug Log，并且不希望这些Log不要跟系统的日志混在一起，可以考虑用下边这个方法create sequence pt_debug_sequence INCREMENT BY 1 -- 每次加几个 START WITH 1 -- 从1开始计数 NOMAXVALUE -- 不设置最大值 NOCYCLE -- 一直累加，不循环 CACHE 10; --1. Create temp table. create table pt_debug_tab (seq INTEGER,text Varchar2(300),datetag Varchar2(30)); --2. Create procedure. create or replace proc

Flexfields FNDSQF Debugger The global variable GLOBAL.FND_FLEX_FNDSQF_DEBUG takes one of the following values: ’OFF’, ’EXCEPTION’, ’FAILURE’, ’DEBUG’. You set GLOBAL.FND_FLEX_FNDSQF_DEBUG through the Examine window before you open your form. 1. From the Help menu, navigate to Diagnostics > Examine.14 – 70 Oracle Applications Developer’s Guide 2. Enter GLOBAL for Block, and FND_FLEX_FNDSQF_DEBUG for Field. Tab to Value field. (If you get a ”variable doesn’t ex