Long Datatype - how to store a big string
405508Mar 10 2004 — edited Mar 11 2004hi 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