PL/SQL (MOSC)

MOSC Banner

Exec remote procedure: PLS-00453: remote operations not permitted on object tables or user-defined t

in PL/SQL (MOSC) 1 commentAnswered

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.

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