xref: /PHP-8.1/ext/oci8/tests/cursor_bind.phpt (revision b5a14e6c)
1--TEST--
2bind and fetch cursor from a statement
3--EXTENSIONS--
4oci8
5--SKIPIF--
6<?php
7$target_dbs = array('oracledb' => true, 'timesten' => false);  // test runs on these DBs
8require(__DIR__.'/skipif.inc');
9?>
10--FILE--
11<?php
12
13require(__DIR__."/connect.inc");
14
15// Initialization
16
17$stmtarray = array(
18    "drop table cursor_bind_tab",
19    "create table cursor_bind_tab (id NUMBER, value VARCHAR(20))",
20    "insert into cursor_bind_tab values (1, '1')",
21    "insert into cursor_bind_tab values (1, '1')",
22    "insert into cursor_bind_tab values (1, '1')"
23);
24
25oci8_test_sql_execute($c, $stmtarray);
26
27$sql = "
28DECLARE
29TYPE curtype IS REF CURSOR;
30cursor_var curtype;
31BEGIN
32    OPEN cursor_var FOR SELECT id, value FROM cursor_bind_tab;
33    :curs := cursor_var;
34END;
35";
36
37$stmt = oci_parse($c, $sql);
38
39$cursor = oci_new_cursor($c);
40oci_bind_by_name($stmt, ":curs", $cursor, -1, OCI_B_CURSOR);
41
42oci_execute($stmt);
43
44oci_execute($cursor);
45var_dump(oci_fetch_row($cursor));
46var_dump(oci_fetch_row($cursor));
47var_dump(oci_fetch_row($cursor));
48var_dump(oci_fetch_row($cursor));
49
50// Clean up
51
52$stmtarray = array(
53    "drop table cursor_bind_tab"
54);
55
56oci8_test_sql_execute($c, $stmtarray);
57
58?>
59--EXPECT--
60array(2) {
61  [0]=>
62  string(1) "1"
63  [1]=>
64  string(1) "1"
65}
66array(2) {
67  [0]=>
68  string(1) "1"
69  [1]=>
70  string(1) "1"
71}
72array(2) {
73  [0]=>
74  string(1) "1"
75  [1]=>
76  string(1) "1"
77}
78bool(false)
79