Test: /ext/oci8/tests/bug42841.phpt - Version 5.6.0beta2 
| Bug #42841 | oci_new_cursor PHP crash | ||||
|---|---|---|---|---|---|
| Submitted: | 2007-10-03 15:39:01 | Modified: | 2008-01-31 00:38:09 | ||
| From: | pr0head | Assigned: | |||
| Status: | Closed | Package: | OCI8 related | ||
| PHP Version: | 5.2.4 | OS: | Linux version 2.6.20-gentoo-r8 | ||
There is 1 diff reported by users for this test.
| Count | Diff |
|---|---|
1 (100%) |
001+ Warning: oci_connect(): ORA-12541: TNS:no listener in %s/bug42841.php on line 6
002+
003+ Warning: oci_parse() expects parameter 1 to be resource, boolean given in /home/nvellon/src/php-5.6.0beta2/ext/oci8/tests/details.inc on line 52
004+
005+ Warning: oci_error() expects parameter 1 to be resource, boolean given in /home/nvellon/src/php-5.6.0beta2/ext/oci8/tests/details.inc on line 54
006+ oci8_test_sql_execute() error:
007+ create or replace procedure bug42841_proc(out_1 out sys_refcursor) is
008+ begin
009+ open out_1 for select 11 from dual union all select 12 from dual union all select 13 from dual;
010+ end bug42841_proc;
011+
012+
013+ Warning: oci_parse() expects parameter 1 to be resource, boolean given in /home/nvellon/src/php-5.6.0beta2/ext/oci8/tests/details.inc on line 52
014+
015+ Warning: oci_error() expects parameter 1 to be resource, boolean given in /home/nvellon/src/php-5.6.0beta2/ext/oci8/tests/details.inc on line 54
016+ oci8_test_sql_execute() error:
017+ create or replace package bug43449_pkg is
018+ type cursortype is ref Cursor;
019+ function testcursor return cursortype;
020+ end bug43449_pkg;
021+
022+
023+ Warning: oci_parse() expects parameter 1 to be resource, boolean given in /home/nvellon/src/php-5.6.0beta2/ext/oci8/tests/details.inc on line 52
024+
025+ Warning: oci_error() expects parameter 1 to be resource, boolean given in /home/nvellon/src/php-5.6.0beta2/ext/oci8/tests/details.inc on line 54
026+ oci8_test_sql_execute() error:
027+ create or replace package body bug43449_pkg is
028+ function testcursor return cursortype is
029+ retCursor cursorType;
030+ begin
031+ Open retCursor For 'select * from dual';
032+ return retCursor;
033+ end;
034+ end bug43449_pkg;
035+
036+ Test bug 42841: Procedure with OUT cursor parameter
037+ First attempt
038+
039+ Warning: oci_parse() expects parameter 1 to be resource, boolean given in %s/bug42841.php on line 40
040+
041+ Warning: oci_new_cursor() expects parameter 1 to be resource, boolean given in %s/bug42841.php on line 41
042+
043+ Warning: oci_bind_by_name() expects parameter 1 to be resource, null given in %s/bug42841.php on line 42
044+
045+ Warning: oci_execute() expects parameter 1 to be resource, null given in %s/bug42841.php on line 44
046+
047+ Warning: oci_execute() expects parameter 1 to be resource, null given in %s/bug42841.php on line 45
048+
049+ Warning: oci_fetch_array() expects parameter 1 to be resource, null given in %s/bug42841.php on line 47
050+
051+ Warning: oci_free_statement() expects parameter 1 to be resource, null given in %s/bug42841.php on line 51
052+
053+ Warning: oci_free_statement() expects parameter 1 to be resource, null given in %s/bug42841.php on line 52
001- Test bug 42841: Procedure with OUT cursor parameter
002- First attempt
003- array(3) {
004- [0]=>
005- array(1) {
006- [11]=>
007- string(2) "11"
008- }
009- [1]=>
010- array(1) {
011- [11]=>
012- string(2) "12"
013- }
014- [2]=>
015- array(1) {
016- [11]=>
017- string(2) "13"
018- }
019- }
020- Second attempt
021- array(3) {
022- [0]=>
023- array(1) {
024- [11]=>
025- string(2) "11"
026- }
027- [1]=>
028- array(1) {
029- [11]=>
030- string(2) "12"
031- }
032- [2]=>
033- array(1) {
034- [11]=>
035- string(2) "13"
036- }
037- }
038- Test bug 43449: Cursor as function result
039- array(1) {
040- [0]=>
041- array(1) {
042- ["DUMMY"]=>
043- string(1) "X"
044- }
045- }
046- array(1) {
047- [0]=>
048- array(1) {
049- ["DUMMY"]=>
050- string(1) "X"
051- }
052- }
053- Done
054+
055+ Notice: Undefined variable: data1 in %s/bug42841.php on line 53
056+ NULL
057+ Second attempt
058+
059+ Warning: oci_parse() expects parameter 1 to be resource, boolean given in %s/bug42841.php on line 58
060+
061+ Warning: oci_new_cursor() expects parameter 1 to be resource, boolean given in %s/bug42841.php on line 59
062+
063+ Warning: oci_bind_by_name() expects parameter 1 to be resource, null given in %s/bug42841.php on line 60
064+
065+ Warning: oci_execute() expects parameter 1 to be resource, null given in %s/bug42841.php on line 62
066+
067+ Warning: oci_execute() expects parameter 1 to be resource, null given in %s/bug42841.php on line 63
068+
069+ Warning: oci_fetch_array() expects parameter 1 to be resource, null given in %s/bug42841.php on line 65
070+
071+ Warning: oci_free_statement() expects parameter 1 to be resource, null given in %s/bug42841.php on line 69
072+
073+ Warning: oci_free_statement() expects parameter 1 to be resource, null given in %s/bug42841.php on line 70
074+
075+ Notice: Undefined variable: data2 in %s/bug42841.php on line 71
076+ NULL
077+
078+ Warning: oci_new_connect(): ORA-12541: TNS:no listener in %s/bug42841.php on line 104
079+ Test bug 43449: Cursor as function result
080+
081+ Warning: oci_new_cursor() expects parameter 1 to be resource, boolean given in %s/bug42841.php on line 84
082+
083+ Warning: oci_parse() expects parameter 1 to be resource, boolean given in %s/bug42841.php on line 85
084+
085+ Warning: oci_bind_by_name() expects parameter 1 to be resource, null given in %s/bug42841.php on line 86
086+
087+ Warning: oci_execute() expects parameter 1 to be resource, null given in %s/bug42841.php on line 87
088+
089+ Warning: oci_execute() expects parameter 1 to be resource, null given in %s/bug42841.php on line 88
090+
091+ Warning: ocifetchinto() expects parameter 1 to be resource, null given in %s/bug42841.php on line 92
092+
093+ Warning: oci_free_statement() expects parameter 1 to be resource, null given in %s/bug42841.php on line 96
094+
095+ Warning: oci_free_statement() expects parameter 1 to be resource, null given in %s/bug42841.php on line 97
096+ array(0) {
097+ }
098+
099+ Warning: oci_new_cursor() expects parameter 1 to be resource, boolean given in %s/bug42841.php on line 84
100+
101+ Warning: oci_parse() expects parameter 1 to be resource, boolean given in %s/bug42841.php on line 85
102+
103+ Warning: oci_bind_by_name() expects parameter 1 to be resource, null given in %s/bug42841.php on line 86
104+
105+ Warning: oci_execute() expects parameter 1 to be resource, null given in %s/bug42841.php on line 87
106+
107+ Warning: oci_execute() expects parameter 1 to be resource, null given in %s/bug42841.php on line 88
108+
109+ Warning: ocifetchinto() expects parameter 1 to be resource, null given in %s/bug42841.php on line 92
110+
111+ Warning: oci_free_statement() expects parameter 1 to be resource, null given in %s/bug42841.php on line 96
112+
113+ Warning: oci_free_statement() expects parameter 1 to be resource, null given in %s/bug42841.php on line 97
114+ array(0) {
115+ }
116+
117+ Warning: oci_parse() expects parameter 1 to be resource, boolean given in /home/nvellon/src/php-5.6.0beta2/ext/oci8/tests/details.inc on line 52
118+
119+ Warning: oci_error() expects parameter 1 to be resource, boolean given in /home/nvellon/src/php-5.6.0beta2/ext/oci8/tests/details.inc on line 54
120+ oci8_test_sql_execute() error:
121+ drop procedure bug42841_proc
122+
123+
124+ Warning: oci_parse() expects parameter 1 to be resource, boolean given in /home/nvellon/src/php-5.6.0beta2/ext/oci8/tests/details.inc on line 52
125+
126+ Warning: oci_error() expects parameter 1 to be resource, boolean given in /home/nvellon/src/php-5.6.0beta2/ext/oci8/tests/details.inc on line 54
127+ oci8_test_sql_execute() error:
128+ drop package bug43449_pkg
129+
130+ Done
|