1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
|
--TEST--
oci_statement_type()
--SKIPIF--
<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?>
--FILE--
<?php
require dirname(__FILE__)."/connect.inc";
$sqls = Array(
"SELECT * FROM table",
"DELETE FROM table WHERE id = 1",
"INSERT INTO table VALUES(1)",
"UPDATE table SET id = 1",
"DROP TABLE table",
"CREATE OR REPLACE PROCEDURE myproc(v1 NUMBER) as BEGIN DBMS_OUTPUT.PUT_LINE(v1); END;",
"CREATE TABLE table (id NUMBER)",
"ALTER TABLE table ADD (col1 NUMBER)",
"BEGIN NULL; END;",
"DECLARE myn NUMBER BEGIN myn := 1; END;",
"CALL myproc(1)",
"WRONG SYNTAX",
""
);
foreach ($sqls as $sql) {
$s = oci_parse($c, $sql);
var_dump(oci_statement_type($s));
}
echo "Done\n";
?>
--EXPECTF--
string(6) "SELECT"
string(6) "DELETE"
string(6) "INSERT"
string(6) "UPDATE"
string(4) "DROP"
string(6) "CREATE"
string(6) "CREATE"
string(5) "ALTER"
string(5) "BEGIN"
string(7) "DECLARE"
string(4) "CALL"
string(7) "UNKNOWN"
string(7) "UNKNOWN"
Done
|
