Jason,

> > variables. A connection variable has a name and a value, both
> > strings, and is assigned programmatically (a method in the
> > JDBC Connection class). Any DML code (including triggers)
> > can access a connection variable with the sql value
> > expression "cnct.<name>". Connection variable are properties
> > of the attachment/connection and persist through transaction
> > commit and rollback.

<SNIP>

> Your implementation is just about exactly what I was recommending be done.

Apart from the fact that transaction IDs should not survive commits and
rollbacks, that's exactly what I would need too.
I add my share of curiosity to yours. :-)
Ciao
--
____
_/\/ando