Easysoft ODBC-ODBC Bridge

Why doesn't a query return recently inserted data?

Article:
00095
Last Reviewed:
28th October 2008
Revision:
3

Insert statements seem to work okay and an immediate select with the same cursor works to display the data, but when I retry the query the data is gone.

Some ODBC enabled languages have autocommit set to off by default. (In PHP and Perl autocommit is set to on by default.)

There are two options to ensure that insert statements are committed to the database.

  1. Ensure that the relevant autocommit flag is switched on in your connection.
  2. Use appropriate commit and rollback methods in your script.

See the following resources for detailed information on how to do this in individual languages:

Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)


Oracle is a registered trademark of Oracle Corporation and/or its affiliates.