DBA Data[Home] [Help]

APPS.AD_ZD dependencies on DBMS_LOB

Line 80: log(x_log_mod, 'STATEMENT', 'SQL(CLOB): '||dbms_lob.substr(x_sql, 3900));

76: L_CUR integer;
77: L_RET integer;
78: begin
79:
80: log(x_log_mod, 'STATEMENT', 'SQL(CLOB): '||dbms_lob.substr(x_sql, 3900));
81:
82: l_cur := dbms_sql.open_cursor;
83: dbms_sql.parse(l_cur, x_sql, dbms_sql.native);
84: l_ret := dbms_sql.execute(l_cur);

Line 102: log(x_log_mod, 'ERROR', 'ERROR: '||SQLERRM|| 'SQL(CLOB): '||dbms_lob.substr(x_sql, 3900));

98: -- ignore or raise other errors as requested
99: if x_ignore then
100: log(x_log_mod, 'STATEMENT', 'Ignored: '||SQLERRM);
101: else
102: log(x_log_mod, 'ERROR', 'ERROR: '||SQLERRM|| 'SQL(CLOB): '||dbms_lob.substr(x_sql, 3900));
103: raise;
104: end if;
105: end;
106: