At 02:59 AM 29/04/2003 -0500, you wrote:

> > Thanks Helen. Any ideas as to how I could do this?
> >
>
>You could try something like this:
>
>xTmp = gen_id(GEN_MSGS, -gen_id(GEN_MSGS));
>xTmp = gen_id(GEN_MSGIMPORTS, -gen_id(GEN_MSGIMPORTS));
>xTmp = gen_id(GEN_TXNERROR, -gen_id(GEN_TXNERROR));
>
>where xTmp is just an integer variable. Not sure if this executes fast
>enough in a multi-user environment, though.

Hmmm.
It would have to be
xTmp = gen_id(GEN_MSGS, -gen_id(GEN_MSGS, 0));

It's one of those things - "Just because you can, doesn't mean you should"
- like telling your three-y-o to ride his tricycle around the swimming pool.

Since you'd have to ensure absolutely that such code would only ever be
executed whilst sysdba or owner was logged in with exclusive access, you
might as well do it the proper way - with a script.

heLen