Bug #2590

Oracle fetch data [nativecode=ORA-01000: maximum open cursors exceeded]

Details

Submitted	2004-10-22 16:21 UTC
From	p dot kirov at gmail dot com
Status	Bogus
Package	DB_DataObject
PHP Version	4.3.7
OS	Linux
Roadmaps	(Not assigned)

Comments

[2004-10-22 16:21 UTC] p dot kirov at gmail dot com

Description:
------------
Maybe there is problem with free resourseies in db abstraction layer (DB/oci8.php) ?
DB_DataObject 1.7.2 stable
DB 1.6.8 stable
This happend in getLinks() method

Reproduce code:
---------------
while ( $this->obj->fetch() ){
$this->obj->getLinks();
.......

}
}

========.links.ini========
[PARTICIPANTS]
CURRENCYID=CURRENCIES:CURRENCYID

Actual result:
--------------
currencies: GET: CURRENCYID 3 Array ( )
currencies: __find: 1
currencies: CONNECT: USING CACHED CONNECTION
currencies: CONNECT: USING CACHED CONNECTION
currencies: CONNECT: USING CACHED CONNECTION
currencies: CONNECT: USING CACHED CONNECTION
currencies: QUERY: SELECT * FROM "CURRENCIES" WHERE "CURRENCIES"."CURRENCYID" = 3
currencies: Query Error: [db_error: message="DB Error: unknown error" code=-1 mode=return level=notice prefix="" info="SELECT * FROM "CURRENCIES" WHERE "CURRENCIES"."CURRENCYID" = 3 [nativecode=ORA-01000: maximum open cursors exceeded]"]
currencies: __find: CHECK autofetchd 1
currencies: __find: DONE

[2004-11-05 16:17 UTC] p dot kirov at gmail dot com

Yes, i slove my problem in this way.