MCPDBWizard

Documentation  ·  Curating

Working with sequences

A selected sequence yields exactly one tool:

<owner>_<sequence>_nextval

It returns the next value, and nothing else.

The Sequences tab listing sequences across schemas with checkboxes
The Sequences tab. Note the list spans schemas and synonyms — PUBLIC and other schemas’ entries appear beside the connected account’s own. Selecting one exposes nextval and nothing else.

PostgreSQL and MariaDB sequences become the same single nextval tool. What follows is about Oracle’s; theirs differ in the detail — caching and gaps among it — and each database documents them.

If you have never used an Oracle sequence before…

currval is deliberately not exposed

It is session state, and the session an agent’s call ran on is not one it can reason about — pooled, the next call may land on a different factory entirely. A currval tool would return a number that looked meaningful and was not.

Practical notes