hi ppl,

please help me in the following problem.

I want to send a long string from PL-SQL code to dotNet environment. The string length can be as long as 50000 characters. Now since varchar2 has a limit of around 32500 charcters, I declare a variale of LONG.

shogenDetails Long;

Now when I start filling this string in a loop, it works fine as long as the string lenght is less 32800 but after that it gives me numeric or value error?

Any idea how can i send such big string from PL-SQL to dotNet environment??

thanx in advance
Omer