• State Not Answered
  • +2 person also asked this people also asked this
  • Replies 7 replies
  • Subscribers 10 subscribers
  • Views 4847 views
  • Users 0 members are here
Home » Discussions » General

Support Oracle CLOB/NCLOB

Stefan Helzle
A Score Level 3
I need to store long (>4000) text in an Oracle DB. My problem is that there is no supported datatype available. The datatype LONG which is supported by Appian is deprecated by Oracel. The type CLOB/NCLOB is recommended by Oracle, but not supported by Appian.
I read related discussions here and do not want to create/use a plugin.
Any ideas anyone?

OriginalPostID-241816

  Discussion posts and replies are publicly visible

Parents
  • 0
    Hi,
    I can understand your reluctance to use a plugin, but the Stored procedure plugin supports the CLOB datatype and is actively being worked on to support BLOB as well. This is a well used plugin - even recommended by Appian. We hit this plugin many 10's of thousands of times a day without issue.

    Mike
  • 0
    A Score Level 2
     in reply to Mike Lonsdale

    Hi Mike,

    Can you please tell me the plugin name you are using for handling clob and blob structure in Appian . i am facing similar issue as Stefan. where i am  unable to fetch CLOB structure in Appian 

Reply
  • 0
    A Score Level 2
     in reply to Mike Lonsdale

    Hi Mike,

    Can you please tell me the plugin name you are using for handling clob and blob structure in Appian . i am facing similar issue as Stefan. where i am  unable to fetch CLOB structure in Appian 

Children
No Data
© 2025 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.