Thanks Leyne!

> Are you *sure* that no record exist with ID = NULL?
>
> What does this query report?
> SELECT COUNT(*) FROM FAC_VEN_SUC WHERE ID IS NULL

well... I thought It could be some kind of corruption in the database, but after a while, I tried again and it worked... so I guess someone else had a transaction active with a record in null which I could not see...

> Separately, it may be a personal thing but I would use INTEGER and BIGINT types for NUMERIC( 9,0) and NUMERIC( 18,0) domains.
>

I don't remember why at the moment, but I was told, some time ago, to use numeric(9,0) instead of integer... could you please tell me why you prefer integer? I'm always very interested in this kind of "conceptual" things.

Thanks!

-s