If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Long Datatype -- how to store a big string

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??