Support Oracle CLOB/NCLOB

Stefan Helzle

A Score Level 3

over 7 years ago

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?

Discussion posts and replies are publicly visible

Top Replies

Stefan Helzle over 7 years ago +2
A Score Level 3

Sure. But why does Appian not support this directly? Would make things so much easier.

Parents

0 Mike Lonsdale over 7 years ago

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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 punyag0001
A Score Level 2
over 2 years ago 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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 punyag0001
A Score Level 2
over 2 years ago 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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data