Hi PSoni,
Thanks for the help! I checked the version of SQL Plus and it's SQL*PLUS: Release 8.1.6.0.0. Seeing that you're running 8i(NT), Release 8.1.5.0.0 and it works like it would on the 8i(Sparc), Release 8.1.5.0.3. I would assume that Oracle changed the permitted behaviour in Release: 8.1.6.0.0.

Now to find a work around. Someone had recommended trying to use a sequence in a trigger. I'll have to see if that works.

Thanks again,

PFC