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

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