Another DB question. I've created an Oracle sequence as a number generator

Richard over 8 years ago

Another DB question. I've created an Oracle sequence as a number generator and just wish to use the query database node to retrieve "nextval" to create unique names.

However, no matter how I phrase the select statement I get, "The database returned ARV's that may not be supported. "

Ideas? Anyone tried this?

Discussion posts and replies are publicly visible

0 Tim
Certified Lead Developer
over 8 years ago

Have you tried giving it an alias i.e. select my_seq.nextval as newId from dual
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 narasimhaadityac
A Score Level 2
over 8 years ago

Hi Richard, alias your column in order to get it working like. if your sequence name is seq the query could be
SELECT SEQ.NEXTVAL SEQ FROM DUAL
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 cindyv0001 over 3 years ago

What Appian function to use to call the SQL select statement?

SELECT SEQ.NEXTVAL SEQ FROM DUAL
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 cindyv0001 over 3 years ago in reply to cindyv0001

DUAL does not show up in the dropdown list of table when ceating the CDT from the datastore. DUAL is a special Oracle table for executing Oracle functions.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel