ORA-06512: at "FORMSPIDER.BDF_DBOBJECT_QRY", line 318

Question

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

Accepted Answer

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.

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.
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

Answer 2

0

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
139●1●4●36
accept rate: 0%