| Author |
Message
|
| chenna.hari |
 Posted: Thu Dec 13, 2012 3:08 am Post subject: maximum open cursors exceeded |
 |
|
Centurion
Joined: 21 Mar 2009
Posts: 103
|
In ESQL, i have code to delete the records from the database. i am getting the error while deleting the records
[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01000: maximum open cursors exceeded
please can any one suggest what is the issue and how to resolve. |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Thu Dec 13, 2012 6:18 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| MrSmith |
| Posted: Thu Dec 13, 2012 7:50 am Post subject: |
|
|
Master
Joined: 20 Mar 2008
Posts: 215
|
How are you deleting the records within the ESQL with PASSTHRU or an ESQL DELETE statement or calling an external Procedure and is this "Deletion" within a loop.
A little more information would be helpful on how our code is processing this.
_________________
-------- *
“Outside of a dog, a book is man's best friend. Inside of a dog it's too dark to read.” |
|
| Back to top |
|
|
| chenna.hari |
| Posted: Thu Dec 13, 2012 10:38 pm Post subject: |
|
|
Centurion
Joined: 21 Mar 2009
Posts: 103
|
| Deletion in a while loop and using Delete statement in Passthru in ESQL |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Fri Dec 14, 2012 12:40 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| chenna.hari wrote: |
| Deletion in a while loop and using Delete statement in Passthru in ESQL |
Perhaps you should look at one of the two following options
1) refine the delete SQL 'where' clauses so that you delete more or all of the rows in one go.
2) use the while loop and propagate (from within the while loop) to another compute node that does the delete.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| kash3338 |
| Posted: Fri Dec 14, 2012 12:58 am Post subject: |
|
|
Shaman
Joined: 08 Feb 2009
Posts: 709
Location: Chennai, India
|
| smdavies99 wrote: |
| chenna.hari wrote: |
| Deletion in a while loop and using Delete statement in Passthru in ESQL |
Perhaps you should look at one of the two following options
1) refine the delete SQL 'where' clauses so that you delete more or all of the rows in one go.
2) use the while loop and propagate (from within the while loop) to another compute node that does the delete. |
Also there was a discussion on similar issue before,
http://www.mqseries.net/phpBB2/viewtopic.php?t=46360&sid=13481d8a9dc034ddacc226b4dfb399dd
hope it helps in some way. |
|
| Back to top |
|
|
|
|
