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.-

asked 13 Nov '12, 08:40

carriagada's gravatar image

carriagada
7236
accept rate: 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%20Kocak's gravatar image

Ugur Kocak ♦
5616
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
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×3
×1

Asked: 13 Nov '12, 08:40

Seen: 993 times

Last updated: 14 Nov '12, 02:26


© Copyright Gerger 2017