Send my output query into a clob var
Hello team
I need to send my output query into a clob var in order to transfer it to other process
my query looks like
select a.c1
||','
a.c2
||','
a.c3
||','
a.c4
from account a
It finds 20 thousand records approximately
Now, I have not in mind on xml format, I Not want use a result set like Ref cursor.
Idea is The procedure calling would recived a clob that has folloing data:
x,y,z,w<cr>a,b,c,d<cr> ....
<cr> means carrie return (skip line) char
Any body has an Idea in order to get a solution?
I appreciatte any suggest.