Stored Procedure Question

I have a stored procedure that uses a cursor that returns a bunch of values. Before populating the variable that inserts the values into the table, I concatinate the values.

ls_cloth_description := ls_cloth_description||' '||c1_rownum||') '||c1_description||'-'||c1_quantity;


Here is the result:

1) Value1-1 2) Value2-1 3) Value3-1 4) Value4-1 5) Value5-1 6) Value6-1 7) Value7-1 8) Value8-1 9) Value9-1 10) Value10-1 11) Value11-2 12) Value12-2 13) Value13-2

I need to put values 1-7 on one line and values 8-13 on the line below. The maximum values returned are 13. I am using this stored procedure as a bookmark to populate the form field of word document. Could you tell me how this can be accomplished? Thanks.

Hi,
You could use the ascii values for
chr(10), which basically is a linefeed character in Oracle. After the 7th record, you could concatenate this linefeed, and then append the rest 8-13.

Something like
DBMS_OUTPUT.put_line(temp_var||CHR(10));

--Vinita