DBA Data[Home] [Help]

APPS.FND_SYSTEM_ALERT_INTG_UTIL dependencies on DBMS_LOB

Line 103: xmlstr := dbms_lob.SUBSTR(result,32767);

99: xmlstr varchar2(32767);
100: line varchar2(2000);
101: begin
102: config_file := UTL_FILE.FOPEN ('/slot03/oracle/oam12devdb/9.2.0/appsutil/outbound/oam12dev', 'sqlQ.txt', 'W');
103: xmlstr := dbms_lob.SUBSTR(result,32767);
104: loop
105: exit when xmlstr is null;
106: --line := substr(xmlstr,1,instr(xmlstr,chr(10))-1);
107: --dbms_output.put_line('| '||line);