Return to bind_char_2.phpt CVS log

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

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

1.1       misho       1: --TEST--
                      2: SELECT oci_bind_by_name with SQLT_AFC aka CHAR and dates
                      3: --SKIPIF--
                      4: <?php
                      5: if (!extension_loaded('oci8')) die ("skip no oci8 extension");
                      6: require(dirname(__FILE__)."/connect.inc");
                      7: // The bind buffer size edge cases seem to change each DB version.
                      8: if (preg_match('/Release 10\.2\./', oci_server_version($c), $matches) !== 1) {
                      9:     if (preg_match('/Release 11\.2\.0\.2/', oci_server_version($c), $matches) !== 2) {
                     10:         die("skip expected output only valid when using Oracle 10gR2 or 11.2.0.2 databases");
                     11:     }
                     12: }
                     13: if (preg_match('/^11\./', oci_client_version()) != 1) {
                     14:     die("skip test expected to work only with Oracle 11g or greater version of client");
                     15: }
                     16: ?>
                     17: --ENV--
                     18: NLS_LANG=
                     19: --FILE--
                     20: <?php
                     21: 
                     22: require(dirname(__FILE__).'/connect.inc');
                     23: 
                     24: // Initialization
                     25: 
                     26: $stmtarray = array(
                     27:        "alter session set nls_date_format='YYYY-MM-DD'",
                     28:        "drop table bind_char_tab",
                     29:        "create table bind_char_tab (id number, c1 date)",
                     30:        "insert into bind_char_tab values (1, '2008-04-20')",
                     31: );
                     32:                                                 
                     33: oci8_test_sql_execute($c, $stmtarray);
                     34: 
                     35: // Run Test
                     36: 
                     37: $bv1 = '2008-04-20';
                     38: 
                     39: echo "Test 1.1: Type: default.  Length: default\n";
                     40: $s = oci_parse($c, "select * from bind_char_tab where c1 = :bv");
                     41: $r = oci_bind_by_name($s, ":bv", $bv1);
                     42: if ($r)
                     43:    do_e_q($s);
                     44: 
                     45: echo "Test 1.2: Type: AFC.  Length: default\n";
                     46: $r = oci_bind_by_name($s, ":bv", $bv1, -1, SQLT_AFC);
                     47: if ($r)
                     48:        do_e_q($s);
                     49: 
                     50: echo "Test 1.3: Type: AFC:  Length: 0\n";
                     51: $r = oci_bind_by_name($s, ":bv", $bv1, 0, SQLT_AFC);
                     52: if ($r)
                     53:        do_e_q($s);
                     54: 
                     55: echo "Test 1.4: Type: AFC:  Length: strlen\n";
                     56: $r = oci_bind_by_name($s, ":bv", $bv1, strlen($bv1), SQLT_AFC);
                     57: if ($r)
                     58:        do_e_q($s);
                     59: 
                     60: echo "Test 1.5: Type: AFC.  Length: strlen-1\n";
                     61: $r = oci_bind_by_name($s, ":bv", $bv1, strlen($bv1)-1, SQLT_AFC);
                     62: if ($r)
                     63:        do_e_q($s);
                     64: 
                     65: echo "Test 1.6: Type: AFC.  Length: strlen+1\n";
                     66: $r = oci_bind_by_name($s, ":bv", $bv1, strlen($bv1)+1, SQLT_AFC);
                     67: if ($r)
                     68:        do_e_q($s);
                     69: 
                     70: 
                     71: function do_e_q($s)
                     72: {
                     73:        echo "  Querying:\n";
                     74: 
                     75:        $r = @oci_execute($s);
                     76:        if (!$r) {
                     77:                $m = oci_error($s);
                     78:                echo "    Oci_execute error ORA-".$m['code']." Exiting Query\n";
                     79:                return;
                     80:        }
                     81:        while ($row = oci_fetch_array($s, OCI_ASSOC+OCI_RETURN_NULLS)) {
                     82:                foreach ($row as $item) {
                     83:                        echo "    :" . $item . ":\n";
                     84:                }
                     85:        }
                     86: }
                     87: 
                     88: // Cleanup
                     89: $stmtarray = array(
                     90:        "drop table bind_char_tab"
                     91: );
                     92:                                                 
                     93: oci8_test_sql_execute($c, $stmtarray);
                     94: 
                     95: echo "Done\n";
                     96: 
                     97: ?>
                     98: --EXPECT--
                     99: Test 1.1: Type: default.  Length: default
                    100:   Querying:
                    101:     :1:
                    102:     :2008-04-20:
                    103: Test 1.2: Type: AFC.  Length: default
                    104:   Querying:
                    105:     :1:
                    106:     :2008-04-20:
                    107: Test 1.3: Type: AFC:  Length: 0
                    108:   Querying:
                    109:     Oci_execute error ORA-1460 Exiting Query
                    110: Test 1.4: Type: AFC:  Length: strlen
                    111:   Querying:
                    112:     :1:
                    113:     :2008-04-20:
                    114: Test 1.5: Type: AFC.  Length: strlen-1
                    115:   Querying:
                    116:     :1:
                    117:     :2008-04-20:
                    118: Test 1.6: Type: AFC.  Length: strlen+1
                    119:   Querying:
                    120:     :1:
                    121:     :2008-04-20:
                    122: Done