Stored Procedure Question

[ichervin]

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.

[vinitasinha]

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