Re: Oracle Long Data Type in ADO.Net

"Sushil Chordia" <sushilc@online.microsoft.com> wrote in message
news:uouHqTPPDHA.1624@tk2msftngp13.phx.gbl...
> I am having no problems with the following code snippet.
> SQL statements:
> create table test (s long)
> insert into test values ('test')
> select * from test
>
> Code Snippet:
> oraclecommand1.CommandText = "select * from test";
> OracleDataReader oracledatareader1 =
> oraclecommand1.ExecuteReader(CommandBehavior.KeyInfo);
> Boolean boolean1 = oracledatareader1.Read(); // true
> String string1 = oracledatareader1.GetString(0); // returns "test"
>
> Please post a repro if you still see problems

I'd expect that to fail once the long exceeds either 2 or 4k in size. Having
said all that on any supported Oracle platform I'd hope that the datatype
got moved from long to LOB.


--
Niall Litchfield
Oracle DBA
Audit Commission UK