PHP  
 PHP_HEAD
downloads | QA | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | my php.net 
 

Test Failure Report for ext/oci8/tests/connect_scope1.phpt ('Test oci_connect end-of-scope when statement returned')

Script

1: <?php
2:
3:
require(dirname(__FILE__).'/details.inc');
4:
5:
// Initialization
6:
7:
$stmtarray = array(
8:     
"drop table connect_scope1_tab",
9:     
"create table connect_scope1_tab (c1 number)",
10: );
11:
12: if (!empty(
$dbase))
13:     
$c1 oci_new_connect($user,$password,$dbase);
14: else
15:     
$c1 oci_new_connect($user,$password);
16:                                                   
17:
oci8_test_sql_execute($c1$stmtarray);
18:
19:
// Run Test
20:
21:
echo "Test 1 - oci_connect\n";
22:
23: function 
f()
24: {
25:     global 
$user$password$dbase;
26:
27:     if (!empty(
$dbase))
28:         
$c oci_connect($user,$password,$dbase);
29:     else
30:         
$c oci_connect($user,$password);
31:     
$s oci_parse($c"insert into connect_scope1_tab values (1)");
32:     
oci_execute($sOCI_DEFAULT);  // no commit
33:     
return($s); // this keeps the connection refcount positive so the connection isn't closed
34:
}
35:
36:
$s2 f();
37:
38:
// Check nothing committed yet
39:
40:
$s1 oci_parse($c1"select * from connect_scope1_tab");
41:
oci_execute($s1OCI_DEFAULT);
42:
oci_fetch_all($s1$r);
43:
var_dump($r);
44:
45:
// insert 2nd row on returned statement, committing both rows
46:
oci_execute($s2);
47:
48:
// Verify data was committed
49:
50:
$s1 oci_parse($c1"select * from connect_scope1_tab");
51:
oci_execute($s1);
52:
oci_fetch_all($s1$r);
53:
var_dump($r);
54:
55:
// Cleanup
56:
57:
$stmtarray = array(
58:     
"drop table connect_scope1_tab"
59:
);
60:
61:
oci8_test_sql_execute($c1$stmtarray);
62:
63: echo 
"Done\n";
64:
65:
?>
66:

Expected

Test 1 - oci_connect
array(1) {
  ["C1"]=>
  array(0) {
  }
}
array(1) {
  ["C1"]=>
  array(2) {
    [0]=>
    string(1) "1"
    [1]=>
    string(1) "1"
  }
}
Done

Output

***********************************************************************
Fatal NI connect error 12541, connecting to:
 (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=php)(HOST=nex2.php.net)(USER=nlopess)))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))

  VERSION INFORMATION:
	TNS for Linux: Version 11.2.0.2.0 - Beta
	TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Beta
  Time: 17-JUN-2018 05:20:27
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12541
    TNS-12541: TNS:no listener
    ns secondary err code: 12560
    nt main err code: 511
    TNS-00511: No listener

Warning: oci_new_connect(): ORA-12541: TNS:no listener in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect_scope1.php on line 13
    nt secondary err code: 111
    nt OS err code: 0

Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/details.inc on line 52

Warning: oci_error() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/details.inc on line 54
oci8_test_sql_execute() error:
drop table connect_scope1_tab


Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/details.inc on line 52

Warning: oci_error() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/details.inc on line 54
oci8_test_sql_execute() error:
create table connect_scope1_tab (c1 number)

Test 1 - oci_connect


***********************************************************************
Fatal NI connect error 12541, connecting to:
 (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=php)(HOST=nex2.php.net)(USER=nlopess)))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))

  VERSION INFORMATION:
	TNS for Linux: Version 11.2.0.2.0 - Beta
	TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Beta
  Time: 17-JUN-2018 05:20:27
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12541
    TNS-12541: TNS:no listener
    ns secondary err code: 12560
    nt main err code: 511
    TNS-00511: No listener

Warning: oci_connect(): ORA-12541: TNS:no listener in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect_scope1.php on line 28
    nt secondary err code: 111
    nt OS err code: 0

Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect_scope1.php on line 31

Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect_scope1.php on line 32

Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect_scope1.php on line 40

Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect_scope1.php on line 41

Warning: oci_fetch_all() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect_scope1.php on line 42
NULL

Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect_scope1.php on line 46

Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect_scope1.php on line 50

Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect_scope1.php on line 51

Warning: oci_fetch_all() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect_scope1.php on line 52
NULL

Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/details.inc on line 52

Warning: oci_error() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/details.inc on line 54
oci8_test_sql_execute() error:
drop table connect_scope1_tab

Done

Diff

001+ ***********************************************************************
002+ Fatal NI connect error 12541, connecting to:
003+  (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=php)(HOST=nex2.php.net)(USER=nlopess)))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
004+ 
005+   VERSION INFORMATION:
006+ 	TNS for Linux: Version 11.2.0.2.0 - Beta
007+ 	TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Beta
008+   Time: 17-JUN-2018 05:20:27
009+   Tracing not turned on.
010+   Tns error struct:
011+     ns main err code: 12541
012+     TNS-12541: TNS:no listener
013+     ns secondary err code: 12560
014+     nt main err code: 511
015+     TNS-00511: No listener
016+ 
001- Test 1 - oci_connect
002- array(1) {
003-   ["C1"]=>
004-   array(0) {
005-   }
006- }
007- array(1) {
008-   ["C1"]=>
009-   array(2) {
010-     [0]=>
011-     string(1) "1"
012-     [1]=>
013-     string(1) "1"
014-   }
015- }
016- Done
017+ Warning: oci_new_connect(): ORA-12541: TNS:no listener in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect_scope1.php on line 13
018+     nt secondary err code: 111
019+     nt OS err code: 0
020+ 
021+ Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/details.inc on line 52
022+ 
023+ Warning: oci_error() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/details.inc on line 54
024+ oci8_test_sql_execute() error:
025+ drop table connect_scope1_tab
026+ 
027+ 
028+ Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/details.inc on line 52
029+ 
030+ Warning: oci_error() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/details.inc on line 54
031+ oci8_test_sql_execute() error:
032+ create table connect_scope1_tab (c1 number)
033+ 
034+ Test 1 - oci_connect
035+ 
036+ 
037+ ***********************************************************************
038+ Fatal NI connect error 12541, connecting to:
039+  (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=php)(HOST=nex2.php.net)(USER=nlopess)))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
040+ 
041+   VERSION INFORMATION:
042+ 	TNS for Linux: Version 11.2.0.2.0 - Beta
043+ 	TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Beta
044+   Time: 17-JUN-2018 05:20:27
045+   Tracing not turned on.
046+   Tns error struct:
047+     ns main err code: 12541
048+     TNS-12541: TNS:no listener
049+     ns secondary err code: 12560
050+     nt main err code: 511
051+     TNS-00511: No listener
052+ 
053+ Warning: oci_connect(): ORA-12541: TNS:no listener in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect_scope1.php on line 28
054+     nt secondary err code: 111
055+     nt OS err code: 0
056+ 
057+ Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect_scope1.php on line 31
058+ 
059+ Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect_scope1.php on line 32
060+ 
061+ Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect_scope1.php on line 40
062+ 
063+ Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect_scope1.php on line 41
064+ 
065+ Warning: oci_fetch_all() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect_scope1.php on line 42
066+ NULL
067+ 
068+ Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect_scope1.php on line 46
069+ 
070+ Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect_scope1.php on line 50
071+ 
072+ Warning: oci_execute() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect_scope1.php on line 51
073+ 
074+ Warning: oci_fetch_all() expects parameter 1 to be resource, null given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/connect_scope1.php on line 52
075+ NULL
076+ 
077+ Warning: oci_parse() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/details.inc on line 52
078+ 
079+ Warning: oci_error() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/details.inc on line 54
080+ oci8_test_sql_execute() error:
081+ drop table connect_scope1_tab
082+ 
083+ Done

 

Generated at Mon, 18 Jun 2018 17:33:50 +0000 (24 hours ago)

Copyright © 2005-2018 The PHP Group
All rights reserved.