DBA Data[Home] [Help]

APPS.JTF_DECLARATIVE_DIAGNOSTIC dependencies on DBMS_LOB

Line 152: dbms_lob.createTemporary(v_detailsClob,true,dbms_lob.call);

148:
149: v_counter := p_ordernumber;
150:
151: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
152: dbms_lob.createTemporary(v_detailsClob,true,dbms_lob.call);
153: v_summaryString := '';
154:
155: -- addStringToClob('', v_detailsClob);
156:

Line 297: dbms_lob.append(reportClob, v_detailsClob);

293: addStringToClob(v_detailsString, v_detailsClob);
294: v_detailsString := '';
295:
296: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
297: dbms_lob.append(reportClob, v_detailsClob);
298:
299: -- overall status of the testcase
300: -- captured by the following boolean
301:

Line 1580: dbms_lob.createTemporary(tempClob,true,dbms_lob.call);

1576: tmpReportStr LONG;
1577: BEGIN
1578:
1579: IF reportStr IS NOT NULL THEN
1580: dbms_lob.createTemporary(tempClob,true,dbms_lob.call);
1581: tmpReportStr := reportStr;
1582: select vsize(tmpReportStr) into strSize from dual;
1583: dbms_lob.write(tempClob,strSize,1,tmpReportStr);
1584: dbms_lob.append(detailsClob, tempClob);

Line 1583: dbms_lob.write(tempClob,strSize,1,tmpReportStr);

1579: IF reportStr IS NOT NULL THEN
1580: dbms_lob.createTemporary(tempClob,true,dbms_lob.call);
1581: tmpReportStr := reportStr;
1582: select vsize(tmpReportStr) into strSize from dual;
1583: dbms_lob.write(tempClob,strSize,1,tmpReportStr);
1584: dbms_lob.append(detailsClob, tempClob);
1585: END IF;
1586:
1587: EXCEPTION

Line 1584: dbms_lob.append(detailsClob, tempClob);

1580: dbms_lob.createTemporary(tempClob,true,dbms_lob.call);
1581: tmpReportStr := reportStr;
1582: select vsize(tmpReportStr) into strSize from dual;
1583: dbms_lob.write(tempClob,strSize,1,tmpReportStr);
1584: dbms_lob.append(detailsClob, tempClob);
1585: END IF;
1586:
1587: EXCEPTION
1588: WHEN others THEN