Anderson Miranda wrote:

>>
>>My solution is by creating a table which holds record flag for the
>>running trigger. The table should have a field TRANSACTION_ID for
>>storing the CURRENT_TRANSACTION variable.
>>
>
> Anyways, thanks for the suggestion... I'm prolly going to do this way.
>

Don't. In the long run, it doesn't work. Or, if you must, combine it
with the date or some other value that won't repeat. I'd get a number
from a generator and use that, storing it in a special table so it's
accessible within triggers and procedures.

Regards,


Ann