Unanswered: Long Datatype -- how to store a big string
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.
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??