47:
48:
49: BEGIN
50: /* Create Temporary Lob */
51: DBMS_LOB.CREATETEMPORARY(lob_loc,TRUE);
52: /* Open the Lob for read write */
53: DBMS_LOB.OPEN(lob_loc,DBMS_LOB.LOB_READWRITE);
54:
55: buffer := param1 ||' '|| param2 ||' '|| param3;
49: BEGIN
50: /* Create Temporary Lob */
51: DBMS_LOB.CREATETEMPORARY(lob_loc,TRUE);
52: /* Open the Lob for read write */
53: DBMS_LOB.OPEN(lob_loc,DBMS_LOB.LOB_READWRITE);
54:
55: buffer := param1 ||' '|| param2 ||' '|| param3;
56: amount := length(buffer);
57: pos := 1;
57: pos := 1;
58:
59:
60: /* Write to the Lob */
61: DBMS_LOB.WRITE(lob_loc,amount,pos,buffer);
62:
63: /*Close Lob */
64: DBMS_LOB.CLOSE(lob_loc);
65:
60: /* Write to the Lob */
61: DBMS_LOB.WRITE(lob_loc,amount,pos,buffer);
62:
63: /*Close Lob */
64: DBMS_LOB.CLOSE(lob_loc);
65:
66: RETURN lob_loc;
67:
68: END;