Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> OPEN_CURSORS !
When I execute the following query, the number cursors opened increase
with the number of rows returned by the query and I get the oracle error
"maximum cursor opened".=20
Is there a way I can reuse the already opened cursor and not hit the maximum OPEN_CURSOR value?
SELECT po.prod_offer_id, pot.dscr, po.qual_req, po.prod_id, pt.dscr ,
CURSOR (SELECT pi.prod_iden_id, pi.parent_id, pit.dscr, pi.VALUE FROM PROD_IDEN pi, PROD_OFFER_IDEN poi, PROD_IDEN_TYPE pit WHERE pit.prod_iden_type_id =3D pi.prod_iden_type_id AND pi.prod_iden_id =3D poi.prod_iden_id AND poi.prod_offer_id =3D po.prod_offer_id ) FROM PROD_OFFER po, PROD_OFFER_TYPE pot, PROD p, PROD_TYPE pt, PROD_OFFER_AUDNC_PRFLE poap WHERE po.prod_offer_type_id =3D pot.prod_offer_type_id AND po.prod_id =3D p.prod_id
Thanks,
San
![]() |
![]() |