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/bug42134.phpt ('Bug #42134 (Collection error for invalid collection name)')

Script

1: <?php
2:
3:
require(dirname(__FILE__).'/details.inc');
4:
5:
// Test collection creation error for normal connection
6:
7:
if (!empty($dbase)) {
8:     
$c oci_connect($user,$password,$dbase);
9: }
10: else {
11:     
$c oci_connect($user,$password);
12: }
13:
14:
$collection oci_new_collection($c"ABC");
15: if (!
$collection) {
16:     echo 
"Normal connection: New Collection error\n";
17:     
$m oci_error($c);
18:     
var_dump($m);
19: }
20:
21:
// Test collection creation error for new connection
22:
23:
if (!empty($dbase)) {
24:     
$c oci_new_connect($user,$password,$dbase);
25: }
26: else {
27:     
$c oci_new_connect($user,$password);
28: }
29:
30:
$collection oci_new_collection($c"DEF");
31: if (!
$collection) {
32:     echo 
"New connection: New Collection error\n";
33:     
$m oci_error($c);
34:     
var_dump($m);
35: }
36:
37:
// Test collection creation error for persistent connection
38:
39:
if (!empty($dbase)) {
40:     
$c oci_pconnect($user,$password,$dbase);
41: }
42: else {
43:     
$c oci_pconnect($user,$password);
44: }
45:
46:
$collection oci_new_collection($c"GHI");
47: if (!
$collection) {
48:     echo 
"Persistent connection: New Collection error\n";
49:     
$m oci_error($c);
50:     
var_dump($m);
51: }
52:
53: echo 
"Done\n";
54:
55:
?>
56:

Expected

Warning: oci_new_collection(): OCI-22303: type ""."ABC" not found in %s on line %d
Normal connection: New Collection error
array(4) {
  ["code"]=>
  int(22303)
  ["message"]=>
  string(34) "OCI-22303: type ""."ABC" not found"
  ["offset"]=>
  int(0)
  ["sqltext"]=>
  string(0) ""
}

Warning: oci_new_collection(): OCI-22303: type ""."DEF" not found in %s on line %d
New connection: New Collection error
array(4) {
  ["code"]=>
  int(22303)
  ["message"]=>
  string(34) "OCI-22303: type ""."DEF" not found"
  ["offset"]=>
  int(0)
  ["sqltext"]=>
  string(0) ""
}

Warning: oci_new_collection(): OCI-22303: type ""."GHI" not found in %s on line %d
Persistent connection: New Collection error
array(4) {
  ["code"]=>
  int(22303)
  ["message"]=>
  string(34) "OCI-22303: type ""."GHI" not found"
  ["offset"]=>
  int(0)
  ["sqltext"]=>
  string(0) ""
}
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:02:37
  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/bug42134.php on line 8
    nt secondary err code: 111
    nt OS err code: 0

Warning: oci_new_collection() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/bug42134.php on line 14
Normal connection: New Collection error

Warning: oci_error() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/bug42134.php on line 17
NULL


***********************************************************************
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:02:37
  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/bug42134.php on line 24
    nt secondary err code: 111
    nt OS err code: 0

Warning: oci_new_collection() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/bug42134.php on line 30
New connection: New Collection error

Warning: oci_error() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/bug42134.php on line 33
NULL


***********************************************************************
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:02:37
  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_pconnect(): ORA-12541: TNS:no listener in /var/php_gcov/PHP_HEAD/ext/oci8/tests/bug42134.php on line 40
    nt secondary err code: 111
    nt OS err code: 0

Warning: oci_new_collection() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/bug42134.php on line 46
Persistent connection: New Collection error

Warning: oci_error() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/bug42134.php on line 49
NULL
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:02:37
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+ 
017+ Warning: oci_connect(): ORA-12541: TNS:no listener in /var/php_gcov/PHP_HEAD/ext/oci8/tests/bug42134.php on line 8
018+     nt secondary err code: 111
019+     nt OS err code: 0
020+ 
021+ Warning: oci_new_collection() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/bug42134.php on line 14
022+ Normal connection: New Collection error
023+ 
024+ Warning: oci_error() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/bug42134.php on line 17
025+ NULL
026+ 
027+ 
028+ ***********************************************************************
029+ Fatal NI connect error 12541, connecting to:
030+  (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)))
001- Warning: oci_new_collection(): OCI-22303: type ""."ABC" not found in %s on line %d
002- Normal connection: New Collection error
003- array(4) {
004-   ["code"]=>
005-   int(22303)
006-   ["message"]=>
007-   string(34) "OCI-22303: type ""."ABC" not found"
008-   ["offset"]=>
009-   int(0)
010-   ["sqltext"]=>
011-   string(0) ""
012- }
014- Warning: oci_new_collection(): OCI-22303: type ""."DEF" not found in %s on line %d
015- New connection: New Collection error
016- array(4) {
017-   ["code"]=>
018-   int(22303)
019-   ["message"]=>
020-   string(34) "OCI-22303: type ""."DEF" not found"
021-   ["offset"]=>
022-   int(0)
023-   ["sqltext"]=>
024-   string(0) ""
025- }
027- Warning: oci_new_collection(): OCI-22303: type ""."GHI" not found in %s on line %d
028- Persistent connection: New Collection error
029- array(4) {
030-   ["code"]=>
031-   int(22303)
032-   ["message"]=>
033-   string(34) "OCI-22303: type ""."GHI" not found"
034-   ["offset"]=>
035-   int(0)
036-   ["sqltext"]=>
037-   string(0) ""
038- }
032+   VERSION INFORMATION:
033+ 	TNS for Linux: Version 11.2.0.2.0 - Beta
034+ 	TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Beta
035+   Time: 17-JUN-2018 05:02:37
036+   Tracing not turned on.
037+   Tns error struct:
038+     ns main err code: 12541
039+     TNS-12541: TNS:no listener
040+     ns secondary err code: 12560
041+     nt main err code: 511
042+     TNS-00511: No listener
043+ 
044+ Warning: oci_new_connect(): ORA-12541: TNS:no listener in /var/php_gcov/PHP_HEAD/ext/oci8/tests/bug42134.php on line 24
045+     nt secondary err code: 111
046+     nt OS err code: 0
047+ 
048+ Warning: oci_new_collection() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/bug42134.php on line 30
049+ New connection: New Collection error
050+ 
051+ Warning: oci_error() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/bug42134.php on line 33
052+ NULL
053+ 
054+ 
055+ ***********************************************************************
056+ Fatal NI connect error 12541, connecting to:
057+  (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)))
059+   VERSION INFORMATION:
060+ 	TNS for Linux: Version 11.2.0.2.0 - Beta
061+ 	TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Beta
062+   Time: 17-JUN-2018 05:02:37
063+   Tracing not turned on.
064+   Tns error struct:
065+     ns main err code: 12541
066+     TNS-12541: TNS:no listener
067+     ns secondary err code: 12560
068+     nt main err code: 511
069+     TNS-00511: No listener
070+ 
071+ Warning: oci_pconnect(): ORA-12541: TNS:no listener in /var/php_gcov/PHP_HEAD/ext/oci8/tests/bug42134.php on line 40
072+     nt secondary err code: 111
073+     nt OS err code: 0
074+ 
075+ Warning: oci_new_collection() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/bug42134.php on line 46
076+ Persistent connection: New Collection error
077+ 
078+ Warning: oci_error() expects parameter 1 to be resource, bool given in /var/php_gcov/PHP_HEAD/ext/oci8/tests/bug42134.php on line 49
079+ NULL

 

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

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