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