Return to bug40078.phpt CVS log

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

Annotation of embedaddon/php/ext/oci8/tests/bug40078.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: Bug #40078 (ORA-01405 when fetching NULL values using oci_bind_array_by_name())
        !             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: $create_pkg = "
        !            14: CREATE OR REPLACE PACKAGE ARRAYBINDPKG1 AS
        !            15:     TYPE ARRTYPE IS TABLE OF VARCHAR(20) INDEX BY BINARY_INTEGER;
        !            16:     PROCEDURE nullbind(c1 OUT ARRTYPE);
        !            17: END ARRAYBINDPKG1;";
        !            18: $statement = oci_parse($c, $create_pkg);
        !            19: oci_execute($statement);
        !            20: 
        !            21: $create_pkg_body = "
        !            22: CREATE OR REPLACE PACKAGE BODY ARRAYBINDPKG1 AS
        !            23:     PROCEDURE nullbind(c1 OUT ARRTYPE) IS
        !            24:     BEGIN
        !            25:         c1(1) := 'one';
        !            26:         c1(2) := 'two';
        !            27:         c1(3) := '';
        !            28:         c1(4) := 'four';
        !            29:         c1(5) := 'five';
        !            30:     END nullbind;
        !            31: END ARRAYBINDPKG1;";
        !            32: $statement = oci_parse($c, $create_pkg_body);
        !            33: oci_execute($statement);
        !            34: 
        !            35: $statement = oci_parse($c, "BEGIN ARRAYBINDPKG1.nullbind(:c1); END;");
        !            36: 
        !            37: oci_bind_array_by_name($statement, ":c1", $array, 5, 20, SQLT_CHR);
        !            38: 
        !            39: oci_execute($statement);
        !            40: 
        !            41: var_dump($array);
        !            42: 
        !            43: echo "Done\n";
        !            44: ?>
        !            45: --EXPECTF--    
        !            46: array(5) {
        !            47:   [0]=>
        !            48:   string(3) "one"
        !            49:   [1]=>
        !            50:   string(3) "two"
        !            51:   [2]=>
        !            52:   string(0) ""
        !            53:   [3]=>
        !            54:   string(4) "four"
        !            55:   [4]=>
        !            56:   string(4) "five"
        !            57: }
        !            58: Done