oci_rollback(3) [php man page]

OCI_ROLLBACK(3) 														   OCI_ROLLBACK(3)

oci_rollback - Rolls back the outstanding database transaction

SYNOPSIS

       bool oci_rollback (resource  $connection)

DESCRIPTION

	Reverts all uncommitted changes for the Oracle $connection and ends the transaction. It releases all locks held. All Oracle SAVEPOINTS are
       erased.

	A transaction begins when the first SQL statement that changes data is executed with oci_execute(3)  using  the  OCI_NO_AUTO_COMMIT  flag.
       Further	data  changes made by other statements become part of the same transaction. Data changes made in a transaction are temporary until
       the transaction is committed or rolled back. Other users of the database will not see the changes until they are committed.

	When inserting or updating data, using transactions is recommended for relational data consistency and for performance reasons.

PARAMETERS

	      o $connection
		- An Oracle connection identifier, returned by oci_connect(3), oci_pconnect(3) or oci_new_connect(3).

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      oci_rollback(3) example

	      <?php

	      // Insert into several tables, rolling back the changes if an error occurs

	      $conn = oci_connect('hr', 'welcome', 'localhost/XE');

	      $stid = oci_parse($conn, "INSERT INTO mysalary (id, name) VALUES (1, 'Chris')");

	      // The OCI_NO_AUTO_COMMIT flag tells Oracle not to commit the INSERT immediately
	      // Use OCI_DEFAULT as the flag for PHP <= 5.3.1.	The two flags are equivalent
	      $r = oci_execute($stid, OCI_NO_AUTO_COMMIT);
	      if (!$r) {
		  $e = oci_error($stid);
		  trigger_error(htmlentities($e['message']), E_USER_ERROR);
	      }

	      $stid = oci_parse($conn, 'INSERT INTO myschedule (startday) VALUES (12)');
	      $r = oci_execute($stid, OCI_NO_AUTO_COMMIT);
	      if (!$r) {
		  $e = oci_error($stid);
		  oci_rollback($conn);	// rollback changes to both tables
		  trigger_error(htmlentities($e['message']), E_USER_ERROR);
	      }

	      // Commit the changes to both tables
	      $r = oci_commit($conn);
	      if (!r) {
		  $e = oci_error($conn);
		  trigger_error(htmlentities($e['message']), E_USER_ERROR);
	      }

	      ?>

       Example #2

	      Rolling back to a SAVEPOINT example

	      <?php
	      $stid = oci_parse($conn, 'UPDATE mytab SET id = 1111');
	      oci_execute($stid, OCI_NO_AUTO_COMMIT);

	      // Create the savepoint
	      $stid = oci_parse($conn, 'SAVEPOINT mysavepoint');
	      oci_execute($stid, OCI_NO_AUTO_COMMIT);

	      $stid = oci_parse($conn, 'UPDATE mytab SET id = 2222');
	      oci_execute($stid, OCI_NO_AUTO_COMMIT);

	      // Use an explicit SQL statement to rollback to the savepoint
	      $stid = oci_parse($conn, 'ROLLBACK TO SAVEPOINT mysavepoint');
	      oci_execute($stid, OCI_NO_AUTO_COMMIT);

	      oci_commit($conn);  // mytab now has id of 1111
	      ?>

NOTES

       Note

	       Transactions are automatically rolled back when you close the connection, or when the script ends, whichever is soonest.  You  need
	      to explicitly call oci_commit(3) to commit the transaction.

	       Any  call  to  oci_execute(3)  that  uses  OCI_COMMIT_ON_SUCCESS mode explicitly or by default will commit any previous uncommitted
	      transaction.

	       Any Oracle DDL statement such as CREATE or DROP will automatically commit any uncommitted transaction.

SEE ALSO

       oci_commit(3), oci_execute(3).

PHP Documentation Group 													   OCI_ROLLBACK(3)

Check Out this Related Man Page

OCI_FETCH(3)															      OCI_FETCH(3)

oci_fetch - Fetches the next row from a query into internal buffers

SYNOPSIS

       bool oci_fetch (resource  $statement)

DESCRIPTION

	Fetches  the  next  row  from a query into internal buffers accessible either with oci_result(3), or by using variables previously defined
       with oci_define_by_name(3).

	See oci_fetch_array(3) for general information about fetching data.

PARAMETERS

	      o $statement
		-A valid OCI8 statement identifier created by oci_parse(3) and executed by oci_execute(3), or a REF CURSOR statement identifier.

RETURN VALUES

	Returns TRUE on success or FALSE if there are no more rows in the $statement.

EXAMPLES

       Example #1

	      oci_fetch(3) with defined variables

	      <?php

	      $conn = oci_connect('hr', 'welcome', 'localhost/XE');
	      if (!$conn) {
		  $e = oci_error();
		  trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
	      }

	      $sql = 'SELECT location_id, city FROM locations WHERE location_id < 1200';
	      $stid = oci_parse($conn, $sql);

	      // The defines MUST be done before executing
	      oci_define_by_name($stid, 'LOCATION_ID', $locid);
	      oci_define_by_name($stid, 'CITY', $city);

	      oci_execute($stid);

	      // Each fetch populates the previously defined variables with the next row's data
	      while (oci_fetch($stid)) {
		  echo "Location id $locid is $city<br>
";
	      }

	      // Displays:
	      //   Location id 1000 is Roma
	      //   Location id 1100 is Venice

	      oci_free_statement($stid);
	      oci_close($conn);

	      ?>

       Example #2

	      oci_fetch(3) with oci_result(3)

	      <?php

	      $conn = oci_connect('hr', 'welcome', 'localhost/XE');
	      if (!$conn) {
		  $e = oci_error();
		  trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
	      }

	      $sql = 'SELECT location_id, city FROM locations WHERE location_id < 1200';
	      $stid = oci_parse($conn, $sql);
	      oci_execute($stid);

	      while (oci_fetch($stid)) {
		  echo oci_result($stid, 'LOCATION_ID') . " is ";
		  echo oci_result($stid, 'CITY') . "<br>
";
	      }

	      // Displays:
	      //   1000 is Roma
	      //   1100 is Venice

	      oci_free_statement($stid);
	      oci_close($conn);

	      ?>

NOTES

       Note

	       Will not return rows from Oracle Database 12 c Implicit Result Sets. Use oci_fetch_array(3) instead.

SEE ALSO

       oci_define_by_name(3), oci_fetch_all(3), oci_fetch_array(3), oci_fetch_assoc(3), oci_fetch_object(3), oci_fetch_row(3), oci_result(3).

PHP Documentation Group 													      OCI_FETCH(3)

Linux and UNIX Man Pages

oci_rollback(3) [php man page]

Check Out this Related Man Page