>Hi Sergey,
>
>The difference is that each cursor came from a different table, you referred
>in each Select into the same table which was Table1. That was not my
>case. Maybe when you meant Table1 in the second SQL and it was a typo,
>I was not sure. That was enough for me to get the idea.
Yes, it was typo, sorry.
>
>The idea behind all of that manipulation is to find a way to bypass the 8192 characters max problem for each Select statement, by breaking 1 big SQL into small SQLs and re-merge them.
>
Can you show your actual "big" sql select? Maybe we can make it "fit" into 8192 characters.
< snip >
--sb--