Using UDT defined in other schema
Hello All,
I have defined "LOG_PU" Type (object) in "LOGSCHEMA" schema and granted execute on "LOG_PU" type to "LOGUSERS" role.
I have to use "LOG_PU" type in a procedure of another user that has "LOGUSERS" role.
As I define a variable with "LOGSCHEMA.LOG_PU" type, I get compilation error (the type is not recognized).
How do can I declare a variable of a udt type, defined in another user schema?