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 |
Hi, This is the query that fails:
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.
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, |
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 |