I created a User Defined Table Type
in a DB1 database. If I try to declare a variable of this type in a BD2 database procedure it gives me the following error:
The type name 'BLABLA' contains more than the maximum number of prefixes.
As I could not resolve this, I tried to create the same data type in both databases. The statement did not give error, but when trying to send the data type created in the DB2 database to a procedure in DB1 it gives the following error:
"Operant type clash"
Is there any way I can send a table of data from a procedure in a DB2 database to a procedure in a DB1 database?