| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Maximum Cursors Exceeded |
« View previous topic :: View next topic » |
| Author |
Message
|
| ramarao |
 Posted: Wed Sep 28, 2005 4:02 pm Post subject: Maximum Cursors Exceeded |
 |
|
Newbie
Joined: 26 May 2004
Posts: 5
Location: detroit
|
Hi,
While I using the sql code in the Java custom node I got the below
error.
HY000. 1000. [DataDirect][ODBC Oracle driver][Oracle]ORA-01000: maximum open cursors exceeded
I used the following code
int transactionType = MbSQLStatement.SQL_TRANSACTION_COMMIT;
MbSQLStatement stmt = node.createSQLStatement(dataSourceName, statement, transactionType);
stmt.execute(assembly);
stmt.clearStatement();
Thanks,
Ramarao.
_________________
ramarao.manku
developer
miraclesoftware systems
miraclecity
india |
|
| Back to top |
|
 |
| wschutz |
| Posted: Wed Sep 28, 2005 5:18 pm Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
From google:
ORA-01000: maximum open cursors exceeded
Cause: A host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursors per user.
Action: Modify the program to use fewer cursors. If this error occurs often, shut down Oracle, increase the value of OPEN_CURSORS, and then restart Oracle.
_________________
-wayne |
|
| Back to top |
|
|
| ramarao |
| Posted: Thu Sep 29, 2005 8:29 am Post subject: |
|
|
Newbie
Joined: 26 May 2004
Posts: 5
Location: detroit
|
| wschutz wrote: |
From google:
ORA-01000: maximum open cursors exceeded
Cause: A host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursors per user.
Action: Modify the program to use fewer cursors. If this error occurs often, shut down Oracle, increase the value of OPEN_CURSORS, and then restart Oracle. |
In which file we can see the variable OPEN_CURSORS to increase its value
Thanks,
Ramarao
_________________
ramarao.manku
developer
miraclesoftware systems
miraclecity
india |
|
| Back to top |
|
|
| wschutz |
| Posted: Thu Sep 29, 2005 8:53 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
| Quote: |
| In which file we can see the variable OPEN_CURSORS to increase its value |
I would imagine that information would be in your oracle documentation.
_________________
-wayne |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
