Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
+1
person also asked this
people also asked this
Replies
6 replies
Subscribers
9 subscribers
Views
4888 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Export excel to sql smart service
baghavathit
Certified Senior Developer
over 8 years ago
The DB table contains some data with CLOB datatype, while I export using the Export excel to sql smart service, the CLOB datatype data are not available in the excel sheet, the other values are there.
OriginalPostID-244377
Discussion posts and replies are publicly visible
Parents
0
aloks0189
Certified Lead Developer
over 8 years ago
@baghavathis Appian does not support CLOB type directly but Stored procedure plugin of Appian supports the CLOB datatype, and this is well known plugin too. As per my understanding as Appian directly do not support CLOB that's why u might not be able to store in variables and hence while using Export Excel to SQL Smart Service you might be getting empty values, i recommend you use Stored procedure plugin to fetch the Data first and then perform the Operation on that, i hope it will work.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
aloks0189
Certified Lead Developer
over 8 years ago
@baghavathis Appian does not support CLOB type directly but Stored procedure plugin of Appian supports the CLOB datatype, and this is well known plugin too. As per my understanding as Appian directly do not support CLOB that's why u might not be able to store in variables and hence while using Export Excel to SQL Smart Service you might be getting empty values, i recommend you use Stored procedure plugin to fetch the Data first and then perform the Operation on that, i hope it will work.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data