If I execute a series of SQL commands with Oracle database, OCI library, without executing commit and setting it to commit p>
What will Oracle do at the end of running the PHP script? A rollback or a commit?
If I execute a series of SQL commands with Oracle database, OCI library, without executing commit and setting it to commit p>
What will Oracle do at the end of running the PHP script? A rollback or a commit?
PHP does nothing because it is a programming language, the question is whether the library does, but which one is it using? The default in the default DB configuration? Does not make automatic. You must call oci_commit()
. Using OCI_COMMIT_ON_SUCCESS
it will run at the end of the query execution if everything is ok.