OCI不会显示对另一个（非OCI）会话所做记录的更改

Question

I'm using OCI for working with an Oracle database. This works perfectly when inserting, selecting, deleting, etc.

But when I insert some data to the same database and table via the SQL command line OCI doesn't show those changes.

Why can I not see the inserted data via OCI?

Answer 1

You need to commit the changes in your command line session before any other session will see them.

By default the OCI8 extension in PHP auto-commits at the end of execution, if successful. This is unusual for Oracle, where the user must always explicitly commit or rollback any changes.