<buppcpp@...> wrote:

>
> I'm I correct in assuming that you can not call a generator from within a

SP

> if you are using variables?
>
> ex.
> gen_value = GEN_ID ( :gen_name, :gen_increment);

Of course, not.

> I think it has to do with variables.

Nope. Generator name is a SQL identifier which can be never represented with
a variable. Some day you'll want to UPDATE :tab_name SET blah-blah, so I'd
suggest you to change your thinking right now.


Dmitry