getting this weird error this morning, went to recompile a trigger in our app schema (the schema that the formspider application is being built for), I don't really undersand the error as the version control checkbox is unselected for the application.

Can't compile any triggers in our app schema at the moment, all other object types seem fine.

Need to sort this out as its halting development at the moment

Error: ORA-00604: error occurred at recursive SQL level 1 ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "FORMSPIDER.BDF_DBOBJECT_QRY", line 318 ORA-06512: at "FORMSPIDER.API_VERSIONCONTROL", line 219 ORA-06512: at line 7

asked 27 Feb '15, 04:29

apacheuk's gravatar image

apacheuk
1391226
accept rate: 0%


Hi,

This is the query that fails:

select object_type
into v_type_cd
from all_objects
where owner=in_schema_cd
and object_name=in_name_tx;

I suspect we made an error when assuming that all objects in a schema has a unique name. That is not true as far as I know. It is a rare case but it happens. So I guess this is the bug you are running into.

I can think of two quick solutions.

  1. Change the name of one of the objects, so that each object in the schema has a unique name. That is a good idea anyway.
  2. Disable version control for a short while during modifying these objects. You should disable triggers named BDF_SOURCECONTROL_AC and BDF_SOURCECONTROL_AD in the Formspider schema. You can reenable them after you are done modifying the objects with non-unique names.

In the meantime we'll try to find a solution to the bug and hopefully have a fix ready in the next version.

Kind Regards,
Yalim

link

answered 27 Feb '15, 04:54

Yalim's gravatar image

Yalim ♦♦
2.8k5
accept rate: 20%

Cheers, we've decided to take option 1 as we are in the position where we can easily recreate/rename all our triggers that are affected (and there are quite a few!) as like you I don't like having duplicate names for anything.

Cheers for the prompt response.

Simon

link

answered 27 Feb '15, 05:25

apacheuk's gravatar image

apacheuk
1391226
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×44
×5
×3

Asked: 27 Feb '15, 04:29

Seen: 1,055 times

Last updated: 27 Feb '15, 05:25


© Copyright Gerger 2017