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 Tim
Certified Lead Developer
over 9 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

Reply

0 Tim
Certified Lead Developer
over 9 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

Children

No Data