Oracle database extract of a CLOB

[crofte]

created a simple table on an existing database in our environment and populate it with one record like so:

CREATE TABLE R_EXTRACT (

ID INTEGER NOT NULL,

TIME TIMESTAMP DEFAULT SYSTIMESTAMP NOT NULL,

CONTENTS CLOB NOT NULL,

PRIMARY KEY(ID)

) TABLESPACE "LOG";



INSERT INTO R_EXTRACT (ID, CONTENTS) VALUES (1,'This is a test extract file');



I then configured a project within Director with a database task that executes the following sql against that database:



SELECT CONTENTS FROM RTI_EXTRACT WHERE ID = 1



I then added a second task which writes the resultset (which should only be the contents of one column) out to a file.
I tried using both a ‘Write Fixed-Width’ and ‘Write CSV’ tasks, however both resulted in the following error when executing the project.

“Data ttype 'CLOB' is currently not supported by this task”

Can Linoma advise what datatypes are supported for what write tasks? Is there a better way within Director of doing what I have tried to achieve?

[Support_Duane]

You can use Char, VarChar, Binary, Decimal, Integer, Date, Time, TimeStamp and probably others that I'm not aware of. The ones that I know you can't use are BLOB and CLOB.

Since I don't know exactly what you're trying to do, I can't tell you the best way to do it. I'd recommend that you call us at 1-800-949-4696 and take the option for Support or send an e-mail to support@linoma.com.