oci_statement_type

(PHP 5, PECL oci8:1.1-1.2.4)

oci_statement_type — Returns the type of an OCI statement

Description

string oci_statement_type ( resource $statement )

Returns the type of the provided OCI statement .

Parameters

statement: A valid OCI statement identifier.

Return Values

Returns the query type ofstatement as one of the following values:

SELECT
UPDATE
DELETE
INSERT
CREATE
DROP
ALTER
BEGIN
DECLARE
CALL (since PHP 5.2.1 and OCI8 1.2.3)
UNKNOWN

Returns FALSE on error.

Examples

Example #1 oci_statement_type() example


<?php
    $conn = oci_connect("scott", "tiger");
    $sql  = "delete from emp where deptno = 10";

    $stmt = oci_parse($conn, $sql);
    if (oci_statement_type($stmt) == "DELETE") {
        die("You are not allowed to delete from this table<br />");
    }

    oci_close($conn);
?>

Notes

Note: In PHP versions before 5.0.0 you must use ocistatementtype() instead. This name still can be used, it was left as alias of oci_statement_type() for downwards compatability. This, however, is deprecated and not recommended.