PL/SQL (MOSC)

MOSC Banner

Using UDT defined in other schema

in PL/SQL (MOSC) 7 commentsAnswered

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? 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center