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
Replies
17 replies
Subscribers
5 subscribers
Views
7447 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
Column Names and Quotes in Oracle. I have an existing table with all column nam
venkats533
over 10 years ago
Column Names and Quotes in Oracle. I have an existing table with all column names in CAPITAL LETTERS. In my XSD, I gave UPPER CASE letters for column name. But Verify is failing when I am trying to add this entity into a data store. Appian is converting all column names to lower case and adding a quotes around them in DDL scripts. How to resolve this issue in Appian. In other words, how do I make Appian not to use quotes around column name or use the exact name in XSD ?...
OriginalPostID-92697
OriginalPostID-92697
Discussion posts and replies are publicly visible
Parents
0
Christine
Appian Employee
over 10 years ago
Can you also run a describe in the table to (1) make sure all your columns are spelled right in you cdt and (2) your column definitions match.
Appian first tries to find the table based on the definition in the cdt. If it can't find it, yes it will then try to create. When Appian creates, it moves objects in lower case and wraps in ", which tells Oracle to maintain case sensitivity.
It looks like something is wrong with the cdt definition (names or types) not matching. For example, are the columns really only 40 is the pk field really ID, etc
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Christine
Appian Employee
over 10 years ago
Can you also run a describe in the table to (1) make sure all your columns are spelled right in you cdt and (2) your column definitions match.
Appian first tries to find the table based on the definition in the cdt. If it can't find it, yes it will then try to create. When Appian creates, it moves objects in lower case and wraps in ", which tells Oracle to maintain case sensitivity.
It looks like something is wrong with the cdt definition (names or types) not matching. For example, are the columns really only 40 is the pk field really ID, etc
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data