DBA Data[Home] [Help]

APPS.OKC_TERMS_UTIL_GRP dependencies on DBMS_LOB

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

2639: FUNCTION empclob
2640: RETURN CLOB IS
2641: c1 CLOB;
2642: BEGIN
2643: DBMS_LOB.CREATETEMPORARY(c1,true);
2644: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);
2645: DBMS_LOB.WRITE(c1,1,1,' ');
2646: RETURN c1;
2647: END empclob;

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

2640: RETURN CLOB IS
2641: c1 CLOB;
2642: BEGIN
2643: DBMS_LOB.CREATETEMPORARY(c1,true);
2644: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);
2645: DBMS_LOB.WRITE(c1,1,1,' ');
2646: RETURN c1;
2647: END empclob;
2648:

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

2641: c1 CLOB;
2642: BEGIN
2643: DBMS_LOB.CREATETEMPORARY(c1,true);
2644: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);
2645: DBMS_LOB.WRITE(c1,1,1,' ');
2646: RETURN c1;
2647: END empclob;
2648:
2649: FUNCTION tempblob

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

2652: rawbuf RAW(10);
2653: BEGIN
2654: rawbuf := '1234567890123456789';
2655:
2656: DBMS_LOB.CREATETEMPORARY(c1,true);
2657: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);
2658: DBMS_LOB.WRITE(c1,1,10,rawbuf);
2659: RETURN c1;
2660: END tempblob;

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

2653: BEGIN
2654: rawbuf := '1234567890123456789';
2655:
2656: DBMS_LOB.CREATETEMPORARY(c1,true);
2657: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);
2658: DBMS_LOB.WRITE(c1,1,10,rawbuf);
2659: RETURN c1;
2660: END tempblob;
2661:

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

2654: rawbuf := '1234567890123456789';
2655:
2656: DBMS_LOB.CREATETEMPORARY(c1,true);
2657: DBMS_LOB.OPEN(c1,dbms_lob.lob_readwrite);
2658: DBMS_LOB.WRITE(c1,1,10,rawbuf);
2659: RETURN c1;
2660: END tempblob;
2661:
2662: --This API is deprecated. Use GET_CONTRACT_DETAILS_ALL() instead.