oci_statement_type(3) php man page | unix.com

OCI_STATEMENT_TYPE(3)													     OCI_STATEMENT_TYPE(3)

oci_statement_type - Returns the type of a statement

SYNOPSIS
       string oci_statement_type (resource  $statement)

DESCRIPTION
	Returns a keyword identifying the type of the OCI8 $statement.

PARAMETERS
	      o $statement
		- A valid OCI8 statement identifier from oci_parse(3).

RETURN VALUES
	Returns the type of $statement as one of the following strings.

       Statement type

	Returns FALSE on error.

EXAMPLES
       Example #1

	      oci_statement_type(3) example

	      <?php

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

	      $stid = oci_parse($conn, 'DELETE FROM departments WHERE department_id = 130;');
	      if (oci_statement_type($stid) == "DELETE") {
		  trigger_error('You are not allowed to delete from this table', E_USER_ERROR);
	      }
	      else {
		  oci_execute($stid);  // delete the row
	      }

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

	      ?>

PHP Documentation Group 												     OCI_STATEMENT_TYPE(3)