ODBC Cache for Automaticaly generated number columns?

I would like to be able to read an automatically generated unique primary key just after it has been created using ODBC on a Windows platform. I have used the table, sequence and trigger definitions below to generate the unique value.

This works fine. The problem arises when I insert a row into the table, TEST, and want to get the ID column for the row just inserted. I always get a NULL value returned. The ODBC driver does not read the generated value in the database but seems to keeps a cache of the values inserted, and returns NULL because a value was not used for ID when creating the row.

Is there a way around this problem?

CREATE TABLE TEST
(
ID NUMBER PRIMARY KEY,
VAL NUMBER
)
/

CREATE SEQUENCE SEQ_TEST START WITH 1
/

CREATE TRIGGER BIU_TEST BEFORE INSERT OR UPDATE ON TEST FOR EACH ROW
BEGIN
IF INSERTING THEN
SELECT SEQ_TEST.NextVal INTO :new.ID FROM DUAL; ELSIF UPDATING THEN
:new.ID := :old.ID;
END IF;
END; Received on Thu Oct 15 1998 - 00:00:00 CDT