DBA Data[Home] [Help]

APPS.OKC_TERMS_UTIL_GRP dependencies on DBMS_LOB

Line 2753: DBMS_LOB.CREATETEMPORARY(c1,true);

2749: FUNCTION empclob
2750: RETURN CLOB IS
2751: c1 CLOB;
2752: BEGIN
2753: DBMS_LOB.CREATETEMPORARY(c1,true);
2754: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);
2755: DBMS_LOB.WRITE(c1,1,1,' ');
2756: RETURN c1;
2757: END empclob;

Line 2754: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);

2750: RETURN CLOB IS
2751: c1 CLOB;
2752: BEGIN
2753: DBMS_LOB.CREATETEMPORARY(c1,true);
2754: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);
2755: DBMS_LOB.WRITE(c1,1,1,' ');
2756: RETURN c1;
2757: END empclob;
2758:

Line 2755: DBMS_LOB.WRITE(c1,1,1,' ');

2751: c1 CLOB;
2752: BEGIN
2753: DBMS_LOB.CREATETEMPORARY(c1,true);
2754: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);
2755: DBMS_LOB.WRITE(c1,1,1,' ');
2756: RETURN c1;
2757: END empclob;
2758:
2759: FUNCTION tempblob

Line 2766: DBMS_LOB.CREATETEMPORARY(c1,true);

2762: rawbuf RAW(10);
2763: BEGIN
2764: rawbuf := '1234567890123456789';
2765:
2766: DBMS_LOB.CREATETEMPORARY(c1,true);
2767: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);
2768: DBMS_LOB.WRITE(c1,1,10,rawbuf);
2769: RETURN c1;
2770: END tempblob;

Line 2767: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);

2763: BEGIN
2764: rawbuf := '1234567890123456789';
2765:
2766: DBMS_LOB.CREATETEMPORARY(c1,true);
2767: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);
2768: DBMS_LOB.WRITE(c1,1,10,rawbuf);
2769: RETURN c1;
2770: END tempblob;
2771:

Line 2768: DBMS_LOB.WRITE(c1,1,10,rawbuf);

2764: rawbuf := '1234567890123456789';
2765:
2766: DBMS_LOB.CREATETEMPORARY(c1,true);
2767: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);
2768: DBMS_LOB.WRITE(c1,1,10,rawbuf);
2769: RETURN c1;
2770: END tempblob;
2771:
2772: --This API is deprecated. Use GET_CONTRACT_DETAILS_ALL() instead.