OraFAQ Forum: Client Tools » Unable to delete a row

Home » Other » Client Tools » Unable to delete a row (Windows server 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unable to delete a row [message #493315]

Mon, 07 February 2011 05:15

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.

Report message to a moderator

Re: Unable to delete a row [message #493317 is a reply to message #493315]

Mon, 07 February 2011 05:28

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You got this error in TOAD?

Regards
Michel

Report message to a moderator

Re: Unable to delete a row [message #493318 is a reply to message #493317]

Mon, 07 February 2011 05:29

sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore

Member

Yes.

Report message to a moderator

Re: Unable to delete a row [message #493320 is a reply to message #493318]

Mon, 07 February 2011 05:34

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

What happens if you use sqlplus to insert and delete the row?

Report message to a moderator

Re: Unable to delete a row [message #493324 is a reply to message #493320]

Mon, 07 February 2011 05:48

sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore

Member

It got deleted in SQL. Why didn't it work in TOAD, any idea?

Report message to a moderator

Re: Unable to delete a row [message #493328 is a reply to message #493324]

Mon, 07 February 2011 05:56

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Throw away TOAD!

Regards
Michel

Report message to a moderator

Re: Unable to delete a row [message #493329 is a reply to message #493328]

Mon, 07 February 2011 05:57

sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore

Member

I wish i could. Thanks Michel and cookiemonster

Report message to a moderator

Re: Unable to delete a row [message #494403 is a reply to message #493329]

Mon, 14 February 2011 05:08

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.

Report message to a moderator

Re: Unable to delete a row [message #494404 is a reply to message #494403]

Mon, 14 February 2011 05:48

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Unable to delete a row [message #494405 is a reply to message #494403]

Mon, 14 February 2011 05:48

ThomasG
Messages: 3212
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.

Report message to a moderator

Re: Unable to delete a row [message #494406 is a reply to message #494405]

Mon, 14 February 2011 05:58

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.

Report message to a moderator

Re: Unable to delete a row [message #494409 is a reply to message #494406]

Mon, 14 February 2011 06:55

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

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

cookiemonster
Messages: 13966
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.

Report message to a moderator

Previous Topic:	PROMPT & ACCEPT
Next Topic:	Inhibit displaying messages in the "Script Output" window

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 02:12:18 CDT 2025