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;
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:
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
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;
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:
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.