I had the same troubles...
Closing all, Connections, Statements, and Resultsets after usage solved this
problem
"Dang" <mdang_at_bigpond.com.au> schrieb im Newsbeitrag
news:c09lng$7pa$1_at_mws-stat-syd.cdn.telstra.com.au...
> I am running Oracle 8i
>
>
>
> "Dang" <mdang_at_bigpond.com.au> wrote in message
> news:c09lc3$7n2$1_at_mws-stat-syd.cdn.telstra.com.au...
> >
> > I am running a series of Union Queries using a DBLINK.
> > My Query ended with
> >
> > "ORA-01000: maximum open cursor exceeded ORA-02063 preceding line from
DB
> > LINK"
> >
> > SELECT A.*
> > FROM TABLEA_at_DBLINK A
> > UNION ALL
> > SELECT B.*
> > FROM TABLEB_at_DBLINK B
> >
> > etc...
> >
> >
> > Would you know how to avoid this error as I cannot cut down my Query in
> > size.
> >
> > Thank You
> >
> >
>
>
Received on Tue Feb 10 2004 - 10:44:45 CST
