Re: ORA-01000: maximum open cursors exceeded

Hello,

When you use cursor, you open it, you use it and you close it.

So in your code, are you sure you call the function to close the cursor. For example, in C++ you have the destructor of the object, so it free the memory and ....
I know that in Java you don't have pointer and not need to free your pointer.
But check your class to find this "close" function.

How many cursor do you have ?
For example SQLPLUS has one cursor, because one statement at a time. You can have 5 cursors if you have 5 SQL statements in run (insert,update,delete,create,drop, alter, grant ...)

You don't kown how the java class have implement the API/OCI of Oracle ? Can you see the source of the class ?

Perhaps you have to modify the open_cursor in your init<instance>.ora file

I will send you a SQL to see the V$cursor view.

Regards

"lkw" <lkw_at_axiomatique.com> a écrit dans le message news: 91uiqh$97i$1_at_violet.singnet.com.sg...
> hi all,
>
> when using java servlet to call sql queries or stored procedures,
> i encountered this error:
> ORA-01000: maximum open cursors exceeded
>
> so, i know some how the cursors exceeded, but i need to know exactly how
 one
> cursors is being counted?
> in java, when i create one statement is counted as one cursor or other
 else?
> hope that everybody can help me. thanks.
>
>
> lkw.
>
>
Received on Fri Dec 22 2000 - 12:34:24 CET