Oracle Pipelined Table Functions

Question

I try to call pipelined table function on other server by dblink, but get error

"ORA-30626: function/procedure parameters of remote object types are not supported".

Maybe exist some way, how i can execute this function? All works, when not remote.

My query:

select * from table(DP.testpipe@DB_DCPRF_WSTAT)

Just that I adjusted the language to be easier to read, as well as set the error to be more immediately visible. I hoped to make this a better question, giving you a better chance for an answer. — bob-fornal
– bob-fornal, Commented Nov 18, 2016 at 14:34

William Robertson · Accepted Answer · 2016-11-16 14:12:10Z

1

I think you have to wrap it in a view.

Remote side:

create or replace view vv
as
select * from table(dp.testpipe());

Local:

select * from vv@DB_DCPRF_WSTAT;

Passing parameters may get tricky depending on your requirement.

answered Nov 16, 2016 at 14:12

William Robertson

16.1k4 gold badges41 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Unfortunatelly, I'm passing in function parameters.

The asktom page I linked to suggests using application contexts for that.