I am working with an external oracle database I am using an external data s

christophers739

Certified Associate Developer

over 8 years ago

I am working with an external oracle database
I am using an external data store to get 2 values that I have to search by, unfortunately those values are stored on the database as:

number(15)

Which as far as I can tell is a number 15 character’s long which is longer than the largest xsd data type I can find, long, it’s also possible that this will overflow the number(integer) field in apian as well but I don’t know about that.

I do not have to display this number, just compare it.

Does anyone know a way to get this number in a appian friendly format, so I can query using it?

Discussion posts and replies are publicly visible

0 Jim Schweitzer
Certified Lead Developer
over 8 years ago

Not possible to perform calculations on a number that large in Appian. You could map it as a string and display it, but I think Appian only supports calculations up to 10 or 11 digits. I'm on mobile, so I can't link to the docs.

Maybe look into a stored procedures or a generated column in a view as a workaround?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 christophers739
Certified Associate Developer
over 8 years ago

that's what i thought, thank you
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 narasimhaadityac
A Score Level 2
over 8 years ago

@christophers739, Can you please check if we can use the fixed() it returns the value in the string format
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel