Home » SQL & PL/SQL » SQL & PL/SQL » Call a function pipelined with paramert from report
Call a function pipelined with paramert from report [message #240014] Wed, 23 May 2007 22:02 Go to next message
nguyenthiphan
Messages: 2
Registered: May 2007
Junior Member
I'm using Oracle10g in my job,
I created a function with pipelined keyword and parameter in.

When I called the function from report by select SQL or PL/SQL by pass direct parameter such as:

select * from table(tao_bckqdd('1-Mar-2007','%','%'));
--tao_bckqdd is name of function
everything seems ok.
But When i called the function from report by pass parameter by using user parameter of report I got error!!!!!!!

select * from table(tao_bckqdd(:ngaysl,:dkbc,:macn));
Error ORA-22905 cannot access rows from a non-nested table item.

Can everybody help me!!!!!!!!!!!!!!! to call a function from report.
Thanks so much.
Re: Call a function pipelined with paramert from report [message #240030 is a reply to message #240014] Wed, 23 May 2007 23:55 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Is this Oracle Reports?
(If so, we can move this thread to the Reports forum.)
Previous Topic: Difference between inner join and equijoin
Next Topic: Functions call other function.
Goto Forum:
  


Current Time: Tue Dec 06 04:24:07 CST 2016

Total time taken to generate the page: 0.10976 seconds