Test: /ext/oci8/tests/refcur_prefetch_1.phpt - Version 5.5.4    

001- -----------------------------------------------

002- Test with Prefetch value set to 0

003- -----------------------------------------------

004- Fetch Row from PHP

005- array(2) {

006- [0]=>

007- string(%d) "0"

008- [1]=>

009- string(%d) "test0"

010- }

011- Fetch Row from PL/SQL

012- int(1)

013- string(%d) "test1"

014- -----------------------------------------------

015- Test with Prefetch value set to 1

016- -----------------------------------------------

017- Fetch Row from PHP

018- array(2) {

019- [0]=>

020- string(%d) "0"

021- [1]=>

022- string(%d) "test0"

023- }

024- Fetch Row from PL/SQL

025- int(2)

026- string(%d) "test2"

027- -----------------------------------------------

028- Test with Prefetch value set to 501

029- -----------------------------------------------

030- Fetch Row from PHP

031- array(2) {

032- [0]=>

033- string(%d) "0"

034- [1]=>

035- string(%d) "test0"

036- }

037-

038- Warning: oci_execute(): ORA-01002: %s

039- ORA-06512: at "%s.REFCURPKG", line %d

040- ORA-06512: at line %d in %s on line %d

041- Fetch Row from PL/SQL

042- int(0)

043- NULL

044- -----------------------------------------------

045- Test with Prefetch value set to 499

046- -----------------------------------------------

047- Fetch Row from PHP

048- array(2) {

049- [0]=>

050- string(%d) "0"

051- [1]=>

052- string(%d) "test0"

053- }

054- Fetch Row from PL/SQL

055- int(500)

056- string(%d) "test500"

057- -----------------------------------------------

058- Test with Prefetch value set to 250

059- -----------------------------------------------

060- Fetch Row from PHP

061- array(2) {

062- [0]=>

063- string(%d) "0"

064- [1]=>

065- string(%d) "test0"

066- }

067- Fetch Row from PL/SQL

068- int(251)

069- string(%d) "test251"

070- -----------------------------------------------

071- Test with Prefetch value set to 12345

072- -----------------------------------------------

073- Fetch Row from PHP

074- array(2) {

075- [0]=>

076- string(%d) "0"

077- [1]=>

078- string(%d) "test0"

079- }

080-

081- Warning: oci_execute(): ORA-01002: %s

082- ORA-06512: at "%s.REFCURPKG", line %d

083- ORA-06512: at line %d in %s on line %d

084- Fetch Row from PL/SQL

085- int(0)

086- NULL

087- -----------------------------------------------

088- Test with Prefetch value set to -12345

089- -----------------------------------------------

090-

091- Warning: oci_set_prefetch(): Number of rows to be prefetched has to be greater than or equal to 0 in %s on line %d

092- Fetch Row from PHP

093- array(2) {

094- [0]=>

095- string(%d) "0"

096- [1]=>

097- string(%d) "test0"

098- }

099- Fetch Row from PL/SQL

100- int(101)

101- string(%d) "test101"

102- -----------------------------------------------

103- Test with Prefetch value set to -1

104- -----------------------------------------------

105-

106- Warning: oci_set_prefetch(): Number of rows to be prefetched has to be greater than or equal to 0 in %s on line %d

107- Fetch Row from PHP

108- array(2) {

109- [0]=>

110- string(%d) "0"

111- [1]=>

112- string(%d) "test0"

113- }

114- Fetch Row from PL/SQL

115- int(101)

116- string(%d) "test101"

117- Done