Listing 1: ODBC alone does not solve portability issues.

(a) 
INSERT INTO product VALUES (1,'ProductName',1,1.0,GETDATE(),NULL);
SELECT @@IDENTITY;

(b) 
SELECT seqproduct.NEXTVAL INTO :next_id FROM DUAL;
INSERT INTO product VALUES (:next_id, 1,'ProductName',
										 1,1.0,SYSTIMESTAMP,NULL);