Pipelined Function

Question

Hi, I want to know if pipelined functions are supported in the framework. I create one as a workaround to the ref cursors problems, but when i try to create a datasource definition with the following query "select function_pipelined from dual" it fails. Thanks in advance.

Claudio Arriagada.-

Answer 1

0

Hi Claudio,

Yes, you can use pipelined funtions. Your datasource definition query should be as the following:

select * 
from table(function_pipelined)

link

answered 13 Nov '12, 08:53

Ugur Kocak ♦
561●6
accept rate: 23%

Sorry. I make a mistake, it works ok. Just replace "select function_pipelined from dual" with "select * from table(function_pipelined)".

(13 Nov '12, 08:54) carriagada

Thanks Ugur.

(13 Nov '12, 08:55) carriagada

Pipelined Function

Follow this question

Related questions