Passing Object type to a remote database procedure input

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ashaj
    New Member
    • Nov 2011
    • 1

    Passing Object type to a remote database procedure input

    Hi,
    I have a doubt,

    In database db1 I have a procedure,this procedure has to call another procedure in db2

    my requirement is ,we have to pass a table type which is declared in db1 as an input to the procedure which is there in db2

    expamle
    procedure_db1

    begin
    procedure_db2(t able_type tbl_type_db1);

    end

    I am getting the below error illegal reference

    Can you pls help me on this as this is very urgent requirement
Working...