SQL & PL/SQL

Hello,
How can I access a remote function (function return a TYPE)


I want to use something like that:
- on server1
create or replace TYPE VIEW_Row_Type AS OBJECT
(
field1 NUMBER(19),
field2 NUMBER,
field3 VARCHAR2(15),
...
);

create or replace TYPE VIEW4EXP IS TABLE OF VIEW_Row_Type;

create or replace FUNCTION ZZ_Get_VIEW4EXPLIST_Param(paramSTRING IN varchar2 default 'all') RETURN TYPE VIEW4EXP IS
paramVIEW4LIST VIEW4EXP := VIEW4EXP();

...

BEGIN
...
RETURN paramVIEW4LIST ;
END;


- on server2

I want to access this function from a remote server (server2) using a dblink:



select filed1,field2,filed3
FROM Table(Cast(ZZ_Get_VIEW4EXPLIST_Param@server1(numberid) As VIEW4EXP));


OBS: object VIEW4EXP is create identically on server2

So, I want to use TABLE(CAST()) option to access a remote function and get the data like I use some ..select * from table1@server1

Thank You
XaM

Message was edited by:
xamukoru