Home » SQL & PL/SQL » Client Tools » Unable to delete a row (Windows server 2003)
Unable to delete a row [message #493315] Mon, 07 February 2011 05:15 Go to next message
sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore
Member
I have a table by name DCODE.

I insert a row in it(TOAD)
immediately after inserting it, if i try to delete it i am geeting an error saying
ORA-01000: maximum open cursors exceeded.

I have tried to to solve this by increasing the value of OPEN_CURSORS. But still i get the same message.
Re: Unable to delete a row [message #493317 is a reply to message #493315] Mon, 07 February 2011 05:28 Go to previous messageGo to next message
Michel Cadot
Messages: 65388
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You got this error in TOAD?

Regards
Michel
Re: Unable to delete a row [message #493318 is a reply to message #493317] Mon, 07 February 2011 05:29 Go to previous messageGo to next message
sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore
Member
Yes.
Re: Unable to delete a row [message #493320 is a reply to message #493318] Mon, 07 February 2011 05:34 Go to previous messageGo to next message
cookiemonster
Messages: 13017
Registered: September 2008
Location: Rainy Manchester
Senior Member
What happens if you use sqlplus to insert and delete the row?
Re: Unable to delete a row [message #493324 is a reply to message #493320] Mon, 07 February 2011 05:48 Go to previous messageGo to next message
sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore
Member
It got deleted in SQL. Why didn't it work in TOAD, any idea?
Re: Unable to delete a row [message #493328 is a reply to message #493324] Mon, 07 February 2011 05:56 Go to previous messageGo to next message
Michel Cadot
Messages: 65388
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Throw away TOAD!

Regards
Michel
Re: Unable to delete a row [message #493329 is a reply to message #493328] Mon, 07 February 2011 05:57 Go to previous messageGo to next message
sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore
Member
I wish i could. Thanks Michel and cookiemonster
Re: Unable to delete a row [message #494403 is a reply to message #493329] Mon, 14 February 2011 05:08 Go to previous messageGo to next message
sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore
Member
The issue is back. I am unable to delete a row from one of my table. i am getting an error as
ORA-01000: maximum open cursors exceeded.
I need to resolve this issue at the earliest. Pls help.
Re: Unable to delete a row [message #494404 is a reply to message #494403] Mon, 14 February 2011 05:48 Go to previous messageGo to next message
Michel Cadot
Messages: 65388
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not so urgent than that as you took 7 days to come back.
Do you think the answer could change still the last week?

There are only 2 things to do:
1/ Close your cursors
2/ Increase the parameter.

Regards
Michel
Re: Unable to delete a row [message #494405 is a reply to message #494403] Mon, 14 February 2011 05:48 Go to previous messageGo to next message
ThomasG
Messages: 3205
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Have you thrown away Toad yet? That's basically the only way to get rid of Toad bugs.

The other option would be to check with "SELECT * FROM V$OPEN_CURSOR" what cursors are open and try to figure out why they are open.
Re: Unable to delete a row [message #494406 is a reply to message #494405] Mon, 14 February 2011 05:58 Go to previous messageGo to next message
sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore
Member
@Michel: I didn't come across any situation wr i had to edit the entries of my table.
I have done both the things still getting the same error.

@Thomas: I am getting it in SQL* Plus.
Re: Unable to delete a row [message #494409 is a reply to message #494406] Mon, 14 February 2011 06:55 Go to previous messageGo to next message
Michel Cadot
Messages: 65388
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you can't do the following:
CONNECT
DELETE ...
DISCONNECT

I advise you to open a SR to Oracle.

Regards
Michel

[Updated on: Mon, 14 February 2011 06:56]

Report message to a moderator

Re: Unable to delete a row [message #494410 is a reply to message #494406] Mon, 14 February 2011 06:58 Go to previous message
cookiemonster
Messages: 13017
Registered: September 2008
Location: Rainy Manchester
Senior Member
You need to work out what's opening all the cursors then.
Run the query Thomas suggested.
Previous Topic: PROMPT & ACCEPT
Next Topic: Inhibit displaying messages in the "Script Output" window
Goto Forum:
  


Current Time: Fri Feb 23 09:08:49 CST 2018

Total time taken to generate the page: 0.18880 seconds