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