Return to error_bind.phpt CVS log

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

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

1.1     ! misho       1: --TEST--
        !             2: Test some oci_bind_by_name error conditions
        !             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: $drop = "drop table bind_test";
        !            11: $statement = oci_parse($c, $drop);
        !            12: @oci_execute($statement);
        !            13: 
        !            14: $create = "create table bind_test(name varchar(10))";
        !            15: $statement = oci_parse($c, $create);
        !            16: oci_execute($statement);
        !            17: 
        !            18: 
        !            19: echo "Insert value\n";
        !            20: 
        !            21: $name = 'abc';
        !            22: $stmt = oci_parse($c, "insert into bind_test values (:name)");
        !            23: oci_bind_by_name($stmt, ":name", $name, 10, SQLT_CHR);
        !            24: var_dump(oci_execute($stmt));
        !            25: 
        !            26: echo "Test 1 - Assign a resource to the bind variable and execute \n";
        !            27: $name=$c;
        !            28: var_dump(oci_execute($stmt));
        !            29: 
        !            30: echo "Test 2 - Re-bind a resource\n";
        !            31: oci_bind_by_name($stmt, ":name", $c);
        !            32: var_dump(oci_execute($stmt));
        !            33: var_dump($c);
        !            34: 
        !            35: // Use a connection resource instead of a ROWID.
        !            36: echo "Test 3 - Resource mismatch !!\n";
        !            37: $stmt = oci_parse($c, "update bind_test set name='xyz' returning rowid into :r_id");
        !            38: oci_bind_by_name($stmt, ":r_id", $c);
        !            39: var_dump(oci_execute($stmt));
        !            40: 
        !            41: // Clean up
        !            42: 
        !            43: $drop = "drop table bind_test";
        !            44: $statement = oci_parse($c, $drop);
        !            45: @oci_execute($statement);
        !            46: 
        !            47: echo "Done\n";
        !            48: 
        !            49: ?>
        !            50: --EXPECTF--
        !            51: Insert value
        !            52: bool(true)
        !            53: Test 1 - Assign a resource to the bind variable and execute 
        !            54: 
        !            55: Warning: oci_execute(): Invalid variable used for bind in %s on line %d
        !            56: bool(false)
        !            57: Test 2 - Re-bind a resource
        !            58: 
        !            59: Warning: oci_bind_by_name(): Invalid variable used for bind in %s on line %d
        !            60: 
        !            61: Warning: oci_execute(): Invalid variable used for bind in %s on line %d
        !            62: bool(false)
        !            63: resource(%d) of type (oci8 connection)
        !            64: Test 3 - Resource mismatch !!
        !            65: 
        !            66: Warning: oci_bind_by_name(): Invalid variable used for bind in %s on line %d
        !            67: 
        !            68: Warning: oci_execute(): ORA-%r(01008|57000)%r: %s on line %d
        !            69: bool(false)
        !            70: Done