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
Ray
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.
YAHOO GROUPS:
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.
http://tech.groups.yahoo.com/group/toad/
“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:
http://tech.groups.yahoo.com/group/toadbeta/
Description:
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.
SUPPORT:
The link below is for the Quest Support:
https://support.quest.com/Default.aspx
Support can be emailed at:
Support@Quest.com
Support can be reached by phone at:
1.800.306.9329 or 949.754.8000
Pointed member to Yahoo sites and/or Support.