Oracle database extract of a CLOB

Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
2 posts Page 1 of 1

crofte

Posts: 2
Joined: Mon Dec 05, 2011 8:18 am

Post by crofte » Fri Dec 09, 2011 11:24 am
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

Support Specialist
Posts: 66
Joined: Thu Mar 05, 2009 3:49 pm

Post by Support_Duane » Tue Feb 14, 2012 10:34 am
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 [email protected].
2 posts Page 1 of 1