DB LINK : How to avoid ORA-01000 Maximum Open Cursor Exceeded

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 Mon Feb 09 2004 - 22:06:27 CST