oci_statement_type
(PHP 5)
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.