We are doing preliminary testing in 10g prior to migrating our database from 9i to 10g. Our application broke on this sql--

INSERT INTO phantom_process_log (phantom_process_log_id, enc_tran_id, enc_status, start_datetime, stop_datetime, enc_process_time)
VALUES (phantom_process_log_seq.nextval, 1106651771, (SELECT enc_status FROM enc_tran
WHERE enc_tran_id = 1003345970), TO_DATE('2005-12-14 09:55:53','YYYY-MM-DD HH24:MI:SS'), TO_DATE('2005-12-14 09:55:53','YYYY-MM-DD HH24:MI:SS'), 0.016)--

We get an error - ora-01400- can't insert NULL in enc_status. The value is coming from the subquery - SELECT ENC_STATUS from ENC_TRAN where enc_tran_ed = 100345970 -

When I run the subquery stand alone I get a value of 'SU3' so there is a value available.

This insert has run for several years in 8i and 9i so we know it is valid there. What has changed in 10G?

Thanks
Larry