I am sending the results of the select statement to another procedure but I want the results to have column headings followed by the data.
slightwv (䄆 Netminder)
>>but I want the results to have column headings followed by the data.
That is a sqlplus thing. In PL/SQL if/when you are dealing with a cursor, you don't get column headings.
>>I am sending the results of the select statement to another procedure
When I see message_body, I think email. If you are just passing data around, I wouldn't do it as a CLOB. I would use a cursor, XML or some other PL/SQL collection object.