3 Replies Latest reply: Jan 22, 2014 8:04 AM by Hoek RSS

    pass a type over dblink




      If I have defined a type as:


      create or replace type MyType is table of number(10);


      , can I so something like this (this block is executed from machine A):


      varType MyType;
      varType := MyType();
      for i in 1..10 loop
        varType(varType.last) := i;
      end loop;

      -- then call a remote procedure, for which the 3rd parameter is of MyType type


      <schema>.<procedure_name>@<dblink_name<(param1, param2, varType);


      So can I call from machine A, a remote procedure (from machine B), and pass to it that varType parameter of that type? Is this supported over dblink?


      That MyType type is created on both machines.


      Thank you.