Function.oci-statement-type

Aus PHP-Wiki

oci_statement_type — Returns the type of an OCI statement

Beschreibung

string oci_statement_type ( resource $statement )

Returns the type of the provided OCI statement .

Parameter-Liste

statement

• A valid OCI statement identifier.

Rückgabewerte

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.

Beispiele

Beispiel #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);
?>

Anmerkungen

Hinweis: 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.