Return to bug51253.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / oci8 / tests

Annotation of embedaddon/php/ext/oci8/tests/bug51253.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: Bug #51253 (oci_bind_array_by_name() array references)
                      3: --SKIPIF--
                      4: <?php
                      5: $target_dbs = array('oracledb' => true, 'timesten' => false);  // test runs on these DBs
                      6: require(dirname(__FILE__).'/skipif.inc');
                      7: ?> 
                      8: --FILE--
                      9: <?php
                     10: 
                     11: require(dirname(__FILE__).'/connect.inc');
                     12: 
                     13: $drop = "DROP table bind_test";
                     14: $statement = oci_parse($c, $drop);
                     15: @oci_execute($statement);
                     16: 
                     17: $create = "CREATE table bind_test(name VARCHAR(20))";
                     18: $statement = oci_parse($c, $create);
                     19: oci_execute($statement);
                     20: 
                     21: $create_pkg = "
                     22: CREATE OR REPLACE PACKAGE ARRAYBINDPKG1 AS 
                     23:   TYPE ARRTYPE IS TABLE OF VARCHAR(20) INDEX BY BINARY_INTEGER; 
                     24:   PROCEDURE iobind(c1 IN OUT ARRTYPE); 
                     25: END ARRAYBINDPKG1;";
                     26: $statement = oci_parse($c, $create_pkg);
                     27: oci_execute($statement);
                     28: 
                     29: $create_pkg_body = "
                     30: CREATE OR REPLACE PACKAGE BODY ARRAYBINDPKG1 AS 
                     31:   CURSOR CUR IS SELECT name FROM bind_test;
                     32:   PROCEDURE iobind(c1 IN OUT ARRTYPE) IS
                     33:     BEGIN
                     34:     FOR i IN 1..5 LOOP
                     35:       INSERT INTO bind_test VALUES (c1(i));
                     36:     END LOOP;
                     37:     IF NOT CUR%ISOPEN THEN
                     38:       OPEN CUR;
                     39:     END IF;
                     40:     FOR i IN REVERSE 1..5 LOOP
                     41:       FETCH CUR INTO c1(i);
                     42:       IF CUR%NOTFOUND THEN
                     43:         CLOSE CUR;
                     44:         EXIT;
                     45:       END IF;
                     46:     END LOOP;
                     47:   END iobind;
                     48: END ARRAYBINDPKG1;";
                     49: $statement = oci_parse($c, $create_pkg_body);
                     50: oci_execute($statement);
                     51: 
                     52: echo "Test 1\n";
                     53: $statement = oci_parse($c, "BEGIN ARRAYBINDPKG1.iobind(:c1); END;");
                     54: $array1 = array("one", "two", "three", "four", "five");
                     55: $array2 = $array1;
                     56: oci_bind_array_by_name($statement, ":c1", $array2, 5, -1, SQLT_CHR);
                     57: oci_execute($statement);
                     58: 
                     59: var_dump($array1);
                     60: var_dump($array2);
                     61: 
                     62: 
                     63: echo "Test 2\n";
                     64: $statement = oci_parse($c, "BEGIN ARRAYBINDPKG1.iobind(:c1); END;");
                     65: $array1 = array("one", "two", "three", "four", "five");
                     66: $array2 = &$array1;
                     67: oci_bind_array_by_name($statement, ":c1", $array2, 5, -1, SQLT_CHR);
                     68: oci_execute($statement);
                     69: 
                     70: var_dump($array1);
                     71: var_dump($array2);
                     72: 
                     73: 
                     74: echo "Test 3\n";
                     75: $statement = oci_parse($c, "BEGIN ARRAYBINDPKG1.iobind(:c1); END;");
                     76: $array1 = array("one", "two", "three", "four", "five");
                     77: $array2 = &$array1;
                     78: oci_bind_array_by_name($statement, ":c1", $array1, 5, -1, SQLT_CHR);
                     79: oci_execute($statement);
                     80: 
                     81: var_dump($array1);
                     82: var_dump($array2);
                     83: 
                     84: // Cleanup
                     85: $statement = oci_parse($c, "DROP PACKAGE ARRAYBINDPKG1");
                     86: @oci_execute($statement);
                     87: $statement = oci_parse($c, "DROP TABLE BIND_TEST");
                     88: @oci_execute($statement);
                     89: 
                     90: echo "Done\n";
                     91: ?>
                     92: --EXPECT--     
                     93: Test 1
                     94: array(5) {
                     95:   [0]=>
                     96:   string(4) "five"
                     97:   [1]=>
                     98:   string(4) "four"
                     99:   [2]=>
                    100:   string(5) "three"
                    101:   [3]=>
                    102:   string(3) "two"
                    103:   [4]=>
                    104:   string(3) "one"
                    105: }
                    106: array(5) {
                    107:   [0]=>
                    108:   string(4) "five"
                    109:   [1]=>
                    110:   string(4) "four"
                    111:   [2]=>
                    112:   string(5) "three"
                    113:   [3]=>
                    114:   string(3) "two"
                    115:   [4]=>
                    116:   string(3) "one"
                    117: }
                    118: Test 2
                    119: array(5) {
                    120:   [0]=>
                    121:   string(3) "one"
                    122:   [1]=>
                    123:   string(3) "two"
                    124:   [2]=>
                    125:   string(5) "three"
                    126:   [3]=>
                    127:   string(4) "four"
                    128:   [4]=>
                    129:   string(4) "five"
                    130: }
                    131: array(5) {
                    132:   [0]=>
                    133:   string(3) "one"
                    134:   [1]=>
                    135:   string(3) "two"
                    136:   [2]=>
                    137:   string(5) "three"
                    138:   [3]=>
                    139:   string(4) "four"
                    140:   [4]=>
                    141:   string(4) "five"
                    142: }
                    143: Test 3
                    144: array(5) {
                    145:   [0]=>
                    146:   string(4) "five"
                    147:   [1]=>
                    148:   string(4) "four"
                    149:   [2]=>
                    150:   string(5) "three"
                    151:   [3]=>
                    152:   string(3) "two"
                    153:   [4]=>
                    154:   string(3) "one"
                    155: }
                    156: array(5) {
                    157:   [0]=>
                    158:   string(4) "five"
                    159:   [1]=>
                    160:   string(4) "four"
                    161:   [2]=>
                    162:   string(5) "three"
                    163:   [3]=>
                    164:   string(3) "two"
                    165:   [4]=>
                    166:   string(3) "one"
                    167: }
                    168: Done