oci_statement_type — Returns the type of an OCI statement
Description
stringoci_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.