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

Richard over 9 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

Parents

0 narasimhaadityac
A Score Level 2
over 9 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

Reply

0 narasimhaadityac
A Score Level 2
over 9 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

Children

No Data