How does Oracle act after running a PHP script without a commit?

Asked

Viewed 75 times

-1

If I run a series of SQL commands with Oracle database, OCI library, without running the commit and defining that it will not be done commit automatic.

What will Oracle do at the end of running the PHP script? A rollback or a commit?

php oracle commit
  • 2

    This depends on the bank configuration.

  • @rray this question is half wide, right?

  • 4

    Why don’t you test yourself?

  • In part this question answers => What is ACID in a database? which would be the concept of atomicity.

  • Guys, I’ve improved the question and tried to make it clear.

1 answer

2

PHP does nothing because it is a programming language, the question is whether the library does, but what is it using? The default, in the DB default configuration? It does not make automatic. It has to call the oci_commit(). Using OCI_COMMIT_ON_SUCCESS he will be executed at the end of the execution of query if it’s all right.

  • So I’m using OCI myself but without automatic commit. I wonder how Oracle will act in this case.

Browser other questions tagged php oracle commit

You are not signed in. Login or sign up in order to post.