SQL Anywhere Mobile - Problems with Open Cursor Error in Oracle

Author

Problems with Open Cursor Error in Oracle

Leo

2005-03-30, 9:43 am

Hi,

I'm currently using ASA v 9.0.1.1899. I have a problem with
Oracle Open Cursors while trying to Synchronize data. I have
my Oracle server and I synchronize all my data from here.
When many clients try to synchronize at a particular time
frame, I get the following error:

E. 03/10 14:23:43. <1.5>
[EFB9d401f1da0584c51
8bcdc36f2efb1234#N10
8X]: Error: [-10002]
ODBC: [DataDirect][ODBC Oracle Wire Protocol
driver][Oracle]ORA-00604: error occurred at recursive SQL
level 1
ORA-01000: maximum open cursors exceeded
(ODBC State = HY000, Native error code = 604)

I found that this error occurs when the maximum number of
Open Cursors are reached. I tried raising this limit but
after sometime, I faced this error again.

Then I realised that closing the cursors that are open must
be the best solution. Since all the cursors are being
implicitly opened, I cannot use any oracle PL/SQL to close
the cursor.

I wanted to find out if there's any way I can close the open
cursors after/during synchronization by means of any options
that ASA has.

This seems to be a major problem for me and I'm not able to
get the right solution. I would be very much obliged if you
could give me a quick solution to this problem.

Cheers,
Leo

Greg Fenton

2005-03-30, 9:43 am

Leo wrote:
>
> I found that this error occurs when the maximum number of
> Open Cursors are reached. I tried raising this limit but
> after sometime, I faced this error again.
>

Leo,

Are you working with (or are you) "Bob" from the post I just responded to?

Is this problem only occuring with Oracle on AIX (Bob mentioned that it
was not a problem with Oracle on Win2003) ?

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links