Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 349559

Summary:	SQL Results view display NULL instead of the right (CLOB) value as String
Product:	[Tools] Data Tools	Reporter:	boegner-online
Component:	SQL Results View	Assignee:	dtp.sqldevtools-inbox <dtp.sqldevtools-inbox>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	P3
Version:	unspecified
Target Milestone:	---
Hardware:	PC
OS:	Windows 7
Whiteboard:

Description boegner-online

2011-06-16 09:26:51 EDT

Build Identifier: 20100917-0705

We have an Oracle 11 database. When I open up an SQL Scrapbook and query for a CLOB column, NULL is displayed for every row in the result set for the CLOB column. These fields are not null. When I execute the same query in Oracle's SQL Developer I see the correct values.
DTP is connected with Oracle throw the Thin Driver.

Reproducible: Always

Steps to Reproduce:
1. Open up a new SQL-file / SQL-Scrapbook.
2. Type in a query that should display a CLOB column.
3. Execute the query.
4. The SQL Results view displays only NULL values for the CLOB column in both table and text mode.