213: psize NUMBER;
214: offset NUMBER;
215: i NUMBER;
216: BEGIN
217: dbms_lob.createtemporary(paramCLOB,TRUE,DBMS_LOB.CALL);
218: psize := 0;
219: IF(params IS NULL) THEN
220: RETURN paramCLOB;
221: END IF;
229: paramV := nv.NAME || '=' || nv.value;
230: END IF;
231: IF paramV IS NOT NULL THEN
232: psize := length(paramV);
233: offset := DBMS_LOB.GETLENGTH(paramClob) + 1;
234: DBMS_LOB.WRITE(paramCLOB,psize,offset,paramV);
235: END IF;
236: END LOOP;
237: RETURN paramCLOB;
230: END IF;
231: IF paramV IS NOT NULL THEN
232: psize := length(paramV);
233: offset := DBMS_LOB.GETLENGTH(paramClob) + 1;
234: DBMS_LOB.WRITE(paramCLOB,psize,offset,paramV);
235: END IF;
236: END LOOP;
237: RETURN paramCLOB;
238: END;
249: psize NUMBER;
250: offset NUMBER;
251: i NUMBER;
252: BEGIN
253: dbms_lob.createtemporary(paramCLOB,TRUE,DBMS_LOB.CALL);
254: psize := 0;
255: IF(params IS NULL) THEN
256: RETURN paramCLOB;
257: END IF;
267: || ';';
268: END IF;
269: IF paramV IS NOT NULL THEN
270: psize := length(paramV);
271: offset := DBMS_LOB.GETLENGTH(paramClob) + 1;
272: DBMS_LOB.WRITE(paramCLOB,psize,offset,paramV);
273: END IF;
274: END LOOP;
275: RETURN paramCLOB;
268: END IF;
269: IF paramV IS NOT NULL THEN
270: psize := length(paramV);
271: offset := DBMS_LOB.GETLENGTH(paramClob) + 1;
272: DBMS_LOB.WRITE(paramCLOB,psize,offset,paramV);
273: END IF;
274: END LOOP;
275: RETURN paramCLOB;
276: END;