Exec remote procedure: PLS-00453: remote operations not permitted on object tables or user-defined t
Hello guys,
I want to execute remote procedure with parameter where is my user-defined object type .
I read in this case I need assign OID for my type in both local and remote databases and I did it, but it doesn't help. In support I find How to Assign an Object Identifier to an Object Type to share user defined objects in distributed transactions (Doc ID 1390712.1) - but here select from remote tale where column user-defined object type.
But I want to call procedure with parameter>user-defined object type - At first I create this type with oid - but after it didn't work in procedure or it self calling in remote db.