Re: select statement returns only the first character...

On 11 Apr 2005 11:25:33 -0700, "Sean" <seanm555_at_comcast.net> wrote:

>Hello all...
>
>We just upgraded our systems from 8.1.7 to 9.2.0.4. A particular
>varchar2(2000) column is giving me problems:
>
>Using sqlplus I can read the column (Has data like 'This is test data')
>
>Using Oracle 9.2.0.4 client driver and Microsoft ADO 2.1, I only get
>the first character in the column (like 'T').
>
>Doing a concat to surround the result with '***', I get '***This is
>test data***' from sqlplus and get '***T' from the oracle client with
>the same statement. What could possibly be happening? Any ideas?
>Thanks,
>
>Sean

If you don't have issues on a client PC with good ol plain sql*plus, it's Microsoft ADO. Apart from that 9.2.0.4 is not exactly the most recent version, and the ADO driver may be simply incompatible with 9i.

--
Sybrand Bakker, Senior Oracle DBA