> 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));

I knew I was forgetting something. <g>

>
> 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.
>

Agreed, however, it's just one of those tricks you can use if it becomes
absolutely necessary. I agree with you, however, it's something that should
be done outside the context of a normal database program operation.

Woody (TMW)

"Start every day off with a smile and get it over with."
-- W. C. Fields