Oracle and Pipelined function
Posted: Mon 07 Nov 2011 09:16
Hello
I have a package, with a pipelined function.
and, in sql environnement, i can use it :
How can i use it with linq ?
I try many possibility, and i always have errors.
What is The method to use ?
Thanks
Jean-Philippe
I have a package, with a pipelined function.
Code: Select all
PACKAGE "PKG_TEST"
AS
TYPE RTest is RECORD ( dummyText VARCHAR2(100) );
TYPE TableRTest is table of RTest;
FUNCTION GetSelected ( USERNAME VARCHAR2 ) RETURN TableRTest PIPELINED;
END PKG_SELECTED;
Code: Select all
Select * from table(PKG_TEST.GetSelected('jack'))
I try many possibility, and i always have errors.
What is The method to use ?
Thanks
Jean-Philippe