Code Forums - View Single Post - how to get inserted OID once insert a record into MySQL

Mazzman · 05-16-2005, 10:38 AM

A technique that I usally use is to create and use the DB sequece object of that database.

You select the next sequence value from the DataBase using a SQL select statment like "select sequence_name.NEXTVAL from DUEL", Then use that number when you insert a new row.

Very reliable technique.

05-16-2005, 10:38 AM	#3 (permalink)
Mazzman Registered User Join Date: Mar 2005 Posts: 7	A technique that I usally use is to create and use the DB sequece object of that database. You select the next sequence value from the DataBase using a SQL select statment like "select sequence_name.NEXTVAL from DUEL", Then use that number when you insert a new row. Very reliable technique.