Toad World® Forums

TOAD's 'Import Table Data' functionality and NCLOB

Hello I need to update from CSV file data into table with NCLOB DataType column.
I was able to import there everything but not this NCLOB, it was inserted blank.
When I saved the statement importer is creating it was:
Update TABLE1 Set
VALUE = Empty_Clob()
Where ID_TABLE1 = 36701
returning VALUE into ‘Mercedes_Benz’

if I rewrite it manualy to ->
Update TABLE1 Set
VALUE = ‘Mercedes_Benz’
Where ID_TABLE1 = 36701
it works perfectly. So does anybody know how can I make Toad’s Importer to create second statement not the first one?

thanks a lot

Hi there,
During our transition to a new community site, our Development team monitors our Yahoo groups daily, and we hope to see you there.

We are able to respond more quickly via our Yahoo Group (link below).
We hope to see you there for help from our Developers and other Toad for Oracle users.
Thank you. :slight_smile:

“This list is for discussion between Toad users on any topic related to Toad, as well as Oracle, SQL*Net, and related issues as long as they have some relationship to Toad.

Oh, and we talk like Pirates on Fridays.”

OR for the BETA group:
Discussion of problems, setup, and new features in the Beta release version of Toad. Our developers and a very dedicated group of Beta users answer questions here daily.

If needed, our award-winning Support team can help.

The link below is for the Quest Support:

Support can be emailed at:

Support can be reached by phone at:
1.800.306.9329 or 949.754.8000

Pointed member to Yahoo sites and/or Support.