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?
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.