Re: OCINewDescriptor & long fields

On 2000-08-25, thies@digicol.de stated: } > } Does anybody now how to get more than 4000 characters into an Oracle } > } long column??? } > } > It isn't possible. 4000 char is the limit in 8.1.6. Maybe in 8.2 [they } > already moved from a 2000 char limit to 4000 in 8.1.6, so i'm not sure if } > there is much demand for this]. But according to several Oracle dbas here, } > going past the 4000 char limit in a long isn't possible; no } > workarounds. :( } } you are wrong: the limit for LONG is 2GB in 7.x, 8.0.x and } 8.1.x Whoops....I was asking our DBAs about LOBs, and had an off day, mixing characters [~bytes] with gigs... [2 gig is the limit for long, as you state [which is more than 2000 characters :) ] and 4 gig is the limit for LOBs]. Guess I didn't get enough caffeine yesterday, eh? :) /vjl/